Calculate %ge at row level for values in 2 columns

[Steve1309]

I have a table with 3 Columns

Name   Total  Missed

a            598   194

b            35      8

I'd like to create a 4th column to show the percentage of Missed against Total

Like this

Name   Total  Missed %Missed

a            598   194       32.4

b            35      8          22.8

I'm sure this is easy but as a new PowerBi user I'm struggling with this. Not sure whether I need to create a new measure and if so, how. Help greatly appreciated.

Thanks 

[TheoC · Accepted solution]

Hi @Steve1309 

You can create a Calculated Column. Something like the below:

Column = 

VAR _1 = Table[Missed] / Table[Total]

RETURN

IF ( _1 = 0 , 0 , _1 )

Then just click the percentage % button in the main ribbon.

Hopefully this helps!

Theo

[TheoC · Accepted solution]

Hi @Steve1309 

You can create a Calculated Column. Something like the below:

Column = 

VAR _1 = Table[Missed] / Table[Total]

RETURN

IF ( _1 = 0 , 0 , _1 )

Then just click the percentage % button in the main ribbon.

Hopefully this helps!

Theo

[Steve1309 · Accepted solution]

Thank you so much. I think I tried everything but the simplest solution!

[TheoC]

@Steve1309 no trouble at all mate. DAX can be very complex, but it can also be very simple. All the best with your Power BI journey! 🙂