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,108 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
• 16,840 points
134 views
0 votes
1 answer

How can I format Power BI visuals to dynamically change based on user-selected measures or dimensions?

Dynamically change Power BI visuals corresponding to ...READ MORE

answered Dec 30, 2024 in Power BI by Anu
• 2,840 points

edited Mar 6 185 views
0 votes
1 answer

How can I create a dynamic date range filter that automatically adjusts based on user-selected slicer values?

To create a dynamic date range filter ...READ MORE

answered 6 days ago in Power BI by anonymous
• 19,330 points
53 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,481 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,567 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,436 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,085 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,460 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,039 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