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

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi mukhan169 

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

    Regards,

     

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

      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's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi mukhan169 

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

        Regards,