Forum Discussion

TotunG's avatar
TotunG
Icon for Resolver I rankResolver I
3 years ago
Solved

Filter 0 from One Matrix Column Only

Hey,   I have a Matrix table with Values which appear in 3 categories (Table example below):   Category Value A 10 A 0 B 0 C 0 B 30 C 20   When displaying...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • ERD's avatar
    ERD
    3 years ago

    Add it to the visual filters and set the value to 1.

     

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

TotunG , you can use this measure for filtering: 

Measure = IF(SELECTEDVALUE(Table[Category]) = "C" && SELECTEDVALUE(Table[Value]) = 0, 0, 1)

Set it equal to 1 in the matrix visual filters.

  • TotunG's avatar
    TotunG
    Icon for Resolver I rankResolver I
    3 years ago

    Nice - thank you. I get this can be used as a sort of indicator now. But I'm still struggling to get this to filter out Category C 0 values only? Do you know the next steps to this?

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Add it to the visual filters and set the value to 1.

       

      • TotunG's avatar
        TotunG
        Icon for Resolver I rankResolver I
        2 years ago

        Appreciate the help, although it still doesn't work. I'll give you kudos tho.