Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Display empty if another value is equal to a specific value

Hi guys,   I have a data table like below   and I would like to display a table with the result like this  In fact, when C = YES, I must display empty in A and B.  My solutions requ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    You can create a measure like below:-

     

     

    _A = IF(MAX('Table (3)'[C]) = "Yes",BLANK(),MAX('Table (3)'[A]))
    _B = IF(MAX('Table (3)'[C]) = "Yes",BLANK(),MAX('Table (3)'[B]))

     

     

    Enable "Show item with no data"

     

     

     

    Output:-

     

     

    Thanks,

    Samarth

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

You can create a measure like below:-

 

 

_A = IF(MAX('Table (3)'[C]) = "Yes",BLANK(),MAX('Table (3)'[A]))
_B = IF(MAX('Table (3)'[C]) = "Yes",BLANK(),MAX('Table (3)'[B]))

 

 

Enable "Show item with no data"

 

 

 

Output:-

 

 

Thanks,

Samarth