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,480 points
3,131 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.

Also Refer:

How do you write DAX expressions that work well with disconnected tables and slicers?

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

Related Questions In Power BI

0 votes
0 answers
0 votes
2 answers

How do I create a Power BI visual that dynamically adjusts based on user-selected filters and slicers?

The application of slicers and filters in ...READ MORE

answered Jan 23 in Power BI by anonymous
• 22,330 points
167 views
0 votes
1 answer

How do I create a calculation that applies different filters based on a user-selected slicer option?

Disconnected Table with DAX Measure using SWITCH() ...READ MORE

answered Mar 25 in Power BI by anonymous
• 24,110 points
74 views
0 votes
1 answer

How can I use DAX to generate a dynamic ranking that changes based on selected filters?

You can create a dynamic ranking measure ...READ MORE

answered Mar 25 in Power BI by anonymous
• 24,110 points
63 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,050 points
1,514 views
0 votes
4 answers

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

R|ight click on the table you want ...READ MORE

answered Nov 18, 2022 in Power BI by Madelein Tolmay
79,682 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
19,480 views
0 votes
1 answer

How to Split Columns in Power BI?

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

answered Jan 6, 2024 in Power BI by anonymous
• 1,420 points
1,127 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,770 points
56,563 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,770 points
23,120 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