Create Total Measure with a Slicer

AbbyLear — Wed, 11 May 2022 15:01:22 GMT

Hi guys,

Fairly new to PowerBI so would be great if someone can enlighten me here on what formula I should use.

Table columns:

Date

Product Category

Quantity Sold

I did the following:

1. Created a measure called "Total Sold" which is the sum of the quantity sold column.

2. In visual, I added a slicer based on the Date - so that I can filter on quarters.

3. In visual, I also created a matrix with Product Category as rows, and "Total Sold" as the first column.

I want to:

a. Create a measure which calculates the total of quantity sold

b. Create another measure which calculates the % of total (so, will be Total sold Divided by the new measure created above.)

For a., I used formula "calculate([Total sold], all ('table_name')). However, it looks like it removed all filters, including the one that came from the slicer and returned the total quantity, while I wanted it to return the total quantity for the selected quarter on the slicer. Can anyone please help?

Thanks!

Re: Create Total Measure with a Slicer

Arul — Wed, 11 May 2022 16:01:10 GMT

AbbyLear ,

try this

calculate([Total sold], ALLSELECTED ('table_name'))

Thanks,

Arul

Re: Create Total Measure with a Slicer

AbbyLear — Wed, 11 May 2022 16:08:43 GMT

It worked! Thanks a lot Arul.

Re: Create Total Measure with a Slicer

Arul — Wed, 11 May 2022 16:20:36 GMT

AbbyLear ,

If it solves your issue, mark it as accepted solution and a kudo would be great!!!

topic Re: Create Total Measure with a Slicer in DAX Commands and Tips

Create Total Measure with a Slicer

Re: Create Total Measure with a Slicer

Re: Create Total Measure with a Slicer

Re: Create Total Measure with a Slicer