TOTAL- how to use DAX syntax to refer to this column?

[Anonymous]

Hi, 

using switch function 

In follwoing scenarion ... 

If(SELECTEDVALUE('ADMIN_step2_cost centers'[Group ])<>"Admin","ABC",0)

Total="ABC"

How to refer to Total column in the following scenario... 

If(SELECTEDVALUE('ADMIN_step2_cost centers'[Group ])="Total","ABC",0)

 to have 
Total="ABC" 

The "Total" is not included in ADMIN_step2_cost centers'[Group ], is Total of the matrix 

thx for your reply!

[selimovd]

Hey @Anonymous ,

you can check with the ISFILTERED function if there is a filter context for the column. If there is no filter it should be the total.

So try:

myMeasure =
IF(
    NOT ( ISFILTERED( 'ADMIN_step2_cost centers'[Group ] ) ),
    "ABC",
    0
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Unfortunately Total is treated as other columns.
As a result there are: 
0 for NOT ISFIlTRED
ABC for ISFILTRED