mukhan169Helper III7 years agoDax 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]) ...Show More
parry2kSuper User7 years agomukhan169 something like this Sum Sales = CALCULATE( SUM(Table[Sales]), Table[MISGroup]=3)
mukhan169Helper III to parry2k7 years agoparry2k Thank you butOnly add 0 for MISGroup =3. Otherwise dont. So this one wont work.Thanks for your replyparry2kSuper User to mukhan1697 years agomukhan169 try this Sum Sales = VAR s = CALCULATE( SUM(Table[Sales]), Table[MISGroup]<>3) RETURN IF( ISBLANK(s), 0, s )mukhan169Helper III to parry2k7 years agoparry2k 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.Show More
mukhan169Helper III to parry2k7 years agoparry2k Thank you butOnly add 0 for MISGroup =3. Otherwise dont. So this one wont work.Thanks for your reply
parry2kSuper User to mukhan1697 years agomukhan169 try this Sum Sales = VAR s = CALCULATE( SUM(Table[Sales]), Table[MISGroup]<>3) RETURN IF( ISBLANK(s), 0, s )
mukhan169Helper III to parry2k7 years agoparry2k 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.
Related contentDynamic measure filteringAdding filters to a calculated columnAdding two measuresAdding a TOPN Filter to a MeasureAdding previous month measure
