Forum Discussion

mukhan169's avatar
mukhan169
Icon for Helper III rankHelper III
7 years ago

Dax Adding filter to the measure

Good morning experts, I have a table with field MISGroup that contains 0,3,12 or 24 in it. For the following measure, how do I just add "where MISGroup=3"    IPTV = IF(ISBLANK([Total By MIS]) ...
Need Help
mukhan169's avatar
mukhan169
Icon for Helper III rankHelper III
7 years ago

parry2k Thank you but

Only add 0 for MISGroup =3. Otherwise dont. So this one wont work.

Thanks for your reply

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

mukhan169 try this

 

Sum Sales = 
VAR s = CALCULATE( SUM(Table[Sales]), Table[MISGroup]<>3)
RETURN
IF( ISBLANK(s), 0, s )
  • mukhan169's avatar
    mukhan169
    Icon for Helper III rankHelper III
    7 years ago

    parry2k  thank you again.

    I just tried this 

    IPTV Test = CALCULATE(TRUE()|Claims[MISGroup]=3)
    so I can later check for true or false in my if condition.
    It produces that result. I know I am missing something very basic. it should be false for 12. again greatly appriciate your help.