Create Total Measure with a Slicer

[AbbyLear]

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! 

[Arul · Accepted solution]

@AbbyLear ,

try this

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

Thanks,

Arul

[AbbyLear]

It worked! Thanks a lot Arul. 

[Arul]

@AbbyLear ,

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