Changing value of one field in respect to other in Power BI

[Anonymous]

Hi Experts,

I need to implement one logic as explained below.

I need to change the value for one field in respect to measure value in front of it. Like if measure value is <0 then the value of the field should show "NA" as shown.

- All values are coming from same table.

Current Table in Power Bi reportTable should look like this after logic, I dont need to show Measure1 column also

[v-piga-msft · Accepted solution]

Hi @Anonymous,

What about creating a calcuted column with if function?

Column = IF('Table1'[Measure]<0,"NA",'Table1'[Column1])

Best Regards,

Cherry

[Anonymous]

Thanks Cherry,

Can we achieve this using DAX through measures on the report only?

Regards,

mannsandhu963