Forum Discussion

TotunG's avatar
TotunG
Resolver I
2 years ago
Solved

Filter 0 from One Matrix Column Only

Hi,   Posted this issue before but still not resolved. I've got the example PBI to help now. (https://drive.google.com/file/d/194BFC7gDw49tSzkBzqz0CJ6MUmxx7H18/view?usp=sharing)   I have a Matrix...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    TotunG Perhaps something like:

    Complex Selector = 
  VAR __Calculation = CALCULATE( [Measure], [Category] = "C" )
  VAR __Return = IF( __Calculation = 0, 0, 1 )
RETURN
  __Return

    Then use the FILTER pane to filter the visual for when this measure equals 1.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

TotunG Perhaps something like:

Complex Selector = 
  VAR __Calculation = CALCULATE( [Measure], [Category] = "C" )
  VAR __Return = IF( __Calculation = 0, 0, 1 )
RETURN
  __Return

Then use the FILTER pane to filter the visual for when this measure equals 1.

  • TotunG's avatar
    TotunG
    Resolver I
    2 years ago

    Think that worked Greg! I definitely need to use variables more - they always help break down the issue...I tend to want to try nest everything haha.