Forum Discussion

AbbyLear's avatar
AbbyLear
Frequent Visitor
4 years ago
Solved

Create Total Measure with a Slicer

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! 

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User

    AbbyLear ,

    try this

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

    Thanks,

    Arul

      • Arul's avatar
        Arul
        Icon for Super User rankSuper User

        AbbyLear ,

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