Forum Discussion

Prabhu_MDU's avatar
Prabhu_MDU
Advocate I
5 years ago
Solved

Calculate subtotal based on multiple slicer

Dear Experts,    Good Day, hope you are doing good.    Ok, my requirement is quiet different or unusual, we are in a process of replicating the SSRS tabular reports in Power BI, most of the featu...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, Prabhu_MDU ;

    You could try to change the measure as follows:

     

    Payment =
CALCULATE (
    SUM ( [Payment] ),
    FILTER (
        'Table',
        [Company] = MAX ( Slicer1[Group1_Column] )
            && [External] = MAX ( Slicer2[Group2_Column] )
            && [Process Center] = MAX ( Slicer3[Group3_Column] )
            && [State Name] = MAX ( Slicer4[Group4_Column] )))

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Prabhu_MDU , if you are using slicer on country and state which below to same tbale you are putting up filter, they are automatically filter with and (&&) without you doing that

 

'Table'[Country]=MIN('Table'[Country]) ||
'Table'[State]=MIN('Table'[State])

 

This just doing row context comparision 

 

 

with independent tables state and country or can work

 

Measeure =
CALCULATE(
SUM('Table'[Population]),
FILTER(('Table'),
'Table'[Country]=selectedvalue('Country'[Country]) ||
'Table'[State]=selectedvalue('State'[State])
)
)
)

 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

Prabhu_MDU's avatar
Prabhu_MDU
Advocate I
5 years ago

Hi amitchandak , 

My hearrty thanks for your reply, 

This is working same as how my measure works, i.e it is not grouping the values from slicers which is treated as column here . I mean, it is not grouping the columns as like 
Sum(Population) GroupBy (Country,State). It is grouping all the columns, here as per the example Country,State,City,Sum(Population).

 

Please help me to fix this.