Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |