Filtering Two Columns Simultaneously

[JSIQUEI-YYC-ENB]

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 be the table in gree below (it will remove company C from the list).

Column Concingency is a calculated measure

Column forecast is a sum of values from a column in another table 

any help will be greatly apprecited... thanks! 

[Ritaf1983 · Accepted solution]

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

[JSIQUEI-YYC-ENB]

Awesome! simple, but smart solution...! appreciatted. Thanks @Ritaf1983  

[Ritaf1983]

@JSIQUEI-YYC-ENB 
Glad to help 🙂