Display empty if another value is equal to a specific value

[Anonymous]

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 requires a creation of a column in the data model and in order to optimize the performance I would like to do it with Dax language. Do you think it's possible ?

Thank you !

[Samarth_18 · Accepted solution]

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

[Pragati11]

HI @Anonymous ,

You can just create 2 columns in Power BI - one for A and the other one for B.

newA = IF(yourtable[C] = "YES", "", yourtable[A])

newB = IF(yourtable[C] = "YES", "", yourtable[B])

 Replace yourtable with your actual table name in the above DAX expressions.

[Anonymous]

thank you ! 

That's what I have already done but I wondered if it's possible with a measure