Change Measure formula based on filter condition

Anonymous ,

try this

Emp count distinct = 
VAR _disctinctCount = DISTINCTCOUNT('Sample Table'[employeeID])
VAR _result = IF(SELECTEDVALUE('Sample Table'[Type]) = "P",_disctinctCount*0.33,_disctinctCount)
RETURN _result

Thanks,

Arul

Hello Arul  and the forum!

When the 'Type' column is not being used on the layout. The measure is not doing the math. Therefore, I resolved the issue with the dax code below.

Active FTEs (Cal_2) =
VAR _P =
    CALCULATE (
        DISTINCTCOUNT ( EMP_TRAN_FACT[HR Employee ID] ),
        EMP_TRAN_FACT[HR Employee Event Type] = "ACTIVE"
            && EMP_TRAN_FACT[HR Employee Job Type] = "P"
    )
VAR _F =
    CALCULATE (
        DISTINCTCOUNT ( EMP_TRAN_FACT[HR Employee ID] ),
        EMP_TRAN_FACT[HR Employee Event Type] = "ACTIVE"
            && EMP_TRAN_FACT[HR Employee Job Type] = "F"
    )
RETURN
    CALCULATE (
        SUMX (
            VALUES ( EMP_TRAN_FACT[HR Employee Job Type] ),
            IF ( EMP_TRAN_FACT[HR Employee Job Type] = "P", _P * 0.33, _F )
        )
    )