Count Statement in Power BI - Urgent

[kh0050]

Hi All

Please help me to write the below statement in Power BI?

CASE WHEN `TableA`='-' THEN 0 ELSE CONCAT(`TableA`,'0') END

Many Thanks

[kh0050]

Thank you so much Kelly!

[v-kelly-msft · Accepted solution]

Hi @kh0050 ,

If you need a calculated column ,use below dax expression:(based on my sample table)

Column = IF('Table'[A]="-","0",'Table'[A]&0)

If you need a measure,use below dax expression:

Measure = IF(MAX('Table'[A])="-",0,MAX('Table'[A])&0)

For both method,you would see:

For my sample .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!