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.

Prabhu_MDU's avatar
Prabhu_MDU
Advocate I
5 years ago

My humble apologies for the delay in reply.. (all the notification mails went in junk folder, extremely sorry about it). 

Hearty thanks for your great effort v-yalanwu-msft  .. you are much closer to my requirement. but it is not exactly the same. (really sorry).. 
here is the power example for what I am looking for. 
good news is, I am able to bring the expected value using SWITCH. but it is too costly in performance it seems. taking lot of rendering time when I implement the same logic in the real time file. 
please download this sample pbix file and have a look, defenitely it can be easy to help me with this example file. 
I apologies if I am not clear in giving the requirement. 


looking forward to hear from you.. 

https://drive.google.com/file/d/1DzZH6kRiuMaLDDkplW86np4XpTGVJYq0/view?usp=sharing