How to create summary table based on selected filters slicers

0 votes

I am trying to create a visualization based on the quantity and purchase value with data close to the ones given below. But the quantity must be the sum of products purchased by a retailer for the selected period. These products may change the selected items in the filter. 

Nov 12, 2020 in Power BI by anonymous
• 10,520 points
2,761 views

1 answer to this question.

0 votes

Here are the steps you can follow:

1. Create a measure.

Quantity_new =
CALCULATE(SUM('Table'[Quantity]))
Value_new = 
CALCULATE(SUM('Table'[Value]))

2. Result.

You can download the PBIX file from here.

answered Nov 12, 2020 by anonymous
• 65,910 points

Related Questions In Power BI

0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 21, 2019 in Power BI by Avantika
• 1,520 points
1,297 views
+1 vote
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

answered Jul 11, 2019 in Power BI by sindhu
8,959 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 18, 2019 in Power BI by anonymous
• 3,450 points
2,831 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
8,303 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,065 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
77,777 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
18,731 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,380 points
663 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
54,588 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,910 points
22,043 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP