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
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.
  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    mukhan169 to be very honest, without looking at sample data it is very hard to provide the solution. If you can share sample data in excel will help a lot. It will save both of our time.