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 added in the subtotals.

 

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. 

     

3 Replies

  • 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.