Forum Discussion
mukhan169
Helper III
Helper IIIDax 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]) ...
mukhan169Helper III
Helper IIII have sample data file loaded here
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
Microsoft Employee
Microsoft EmployeeHi 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,