Dax Adding filter to the measure

[mukhan169]

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]) && [Sum of Sales]>0 && table[MISGroup]=3 |

0

|Divide([Running Total By MIS]|[Sum of Sales]|0)*1000

)

[parry2k]

@mukhan169 something like this

Sum Sales = CALCULATE( SUM(Table[Sales]), Table[MISGroup]=3)

[mukhan169]

@parry2k Thank you but

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

Thanks for your reply

[parry2k]

@mukhan169 try this

Sum Sales = 
VAR s = CALCULATE( SUM(Table[Sales]), Table[MISGroup]<>3)
RETURN
IF( ISBLANK(s), 0, s )

[mukhan169]

@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]

@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.

[mukhan169]

@parry2k 

I have sample data file loaded here

https://community.powerbi.com/t5/Desktop/Cumulative-Total-per-group-and-month-which-fill-the-missing...

this is a very smart part of a bigger problem I am trying to solve.

its a chart for 3,12 and 24 MIS which are not supposed to cross over each other. I only want to apply formula for 3 mis group for now.

[v-cherch-msft]

Hi @mukhan169 

You may add formula ...&&MAX(Claims[MISGroup])=3.Test it with your sample file as below.

Regards,

[mukhan169]

@v-cherch-msft 
Thank  you but it still doesnt work, its showing nothing for MIS where the count is zero. I am baffeled . But appriciate your help.

[v-cherch-msft]

Hi @mukhan169 

Could you show us your measure and provide a  clear illustrative example about your expected output?

Regards,