Forum Discussion

chandakaushik's avatar
chandakaushik
Helper I
5 years ago
Solved

Create Customized and Conditional subtotals

Hello guys, I am trying to create a conditional subtotal in a PowerPivot. Can someone please help? Subtotal = Rolling Difference GRR + Compass + CaptiveManual + DuePremium Life GRR shouldn't be ad...
DAX
subtotals
  • stevedep's avatar
    stevedep
    5 years ago

    Perhaps this is what you are looking for?

     

    ___SumPolicy = IF(ISFILTERED('Table'[System]), SUM('Table'[Amount]), CALCULATE(SUM('Table'[Amount]), 'Table'[System] <> "AD"))

     

    As seen here:

    As demonstrated here. 

    Link to file here. 

     

    pls mark as solution if so.

     

    Kind regards,

     

    Steve. 

     

stevedep's avatar
stevedep
Memorable Member
5 years ago

Perhaps this is what you are looking for?

 

___SumPolicy = IF(ISFILTERED('Table'[System]), SUM('Table'[Amount]), CALCULATE(SUM('Table'[Amount]), 'Table'[System] <> "AD"))

 

As seen here:

As demonstrated here. 

Link to file here. 

 

pls mark as solution if so.

 

Kind regards,

 

Steve. 

 

chandakaushik's avatar
chandakaushik
Helper I
5 years ago

stevedep Thank youso much! You're awesome! 🙂