Forum Discussion

Helper I

4 years ago

Solved

Pivot with different total

Hi, I created a pivot table with sales MTD YOY%, in the dimensions I entered the Year-Month but in the column total the result of the last column is replicated, that is the month of September. On th...

amitchandak
4 years ago
Morrison , You can use is isfiltered or isinscope to switch the grand total measure

if(isinscope ([Month Year]), [Meausre], [YOY Meausre])

HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

amitchandak

Super User

4 years ago

Morrison , You can use is isfiltered or isinscope to switch the grand total measure

if(isinscope ([Month Year]), [Meausre], [YOY Meausre])

HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Morrison
Helper I
4 years ago
amitchandak thx for the solution 🙂

Forum Discussion

Pivot with different total

Related content

Pivot issue

Pivot / Unpivot?

Different total

Allocating a cost total across different line items

Different formula in total row