Forum Discussion

JSIQUEI-YYC-ENB's avatar
JSIQUEI-YYC-ENB
Helper I
2 years ago
Solved

Filtering Two Columns Simultaneously

Hi everyone,  I am trying to achieve the following filter in my Matrix Table.  I need to apply a filter to remove company which has 0 Contingency AND 0 Forecast at the same time. The resoult should...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi JSIQUEI-YYC-ENB 
    You can create a measure flag like  
    flag = if ([Contingency ]=0 && [Forecast] =0 ,1,0)

    And use this flag as a filter on the matrix.

    **If it is not 0 m but blanks the flag measure will be with isblank()

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly