Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Steve1309
New Member

Calculate %ge at row level for values in 2 columns

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 

2 ACCEPTED SOLUTIONS
TheoC
Super User
Super User

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

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

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

View solution in original post

3 REPLIES 3
TheoC
Super User
Super User

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

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

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

@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! 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.