Format matrix value as a percentage for one row

[oscarV]

Hello everyone,

I'm trying to put a matrix together showing a condensed P&L statement based on the data below. My issue is that I need to divide the P&L values by 1000, EXCEPT the EBITDA %, which I'll need to show as a percent. Please see the data below. Let me know if there is any other information I can provide.

Thank you.

[amitchandak · Accepted solution]

@oscarV , New column

= if([Is In] ="EBITAD %", [Total], [Total]/1000)

it total is measure , then measure

= if(max(Table([Is In]) ="EBITAD %", [Total], [Total]/1000)

[oscarV]

Hello @amitchandak ,

Thank you for helping out! The code below gives me an error.

I'm a bit new to PBI so apologies if I'm not being very clear. What I've done to follow your recommendation was to hit the button circled below:

Any reason why the error might appear?

[v-shex-msft]

Hi @oscarV,

In fact, they are DAX formulas and they are not supported to use this in the query editor. Please save and back to the data view and create a calculated column with these formulas.

Regards,

Xiaoxin Sheng