topic Re: Create Customized and Conditional subtotals in DAX Commands and Tips

Create Customized and Conditional subtotals

chandakaushik — Thu, 24 Sep 2020 18:16:26 GMT

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.

stevedep — Mon, 28 Sep 2020 19:13:27 GMT

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 — Fri, 02 Oct 2020 07:02:54 GMT

chandakaushik , Does this work for you?

chandakaushik — Tue, 13 Oct 2020 16:22:20 GMT

stevedep Thank youso much! You're awesome! 🙂