Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to get PowerBI to display percentage of each row. In the example below I need values of (FailedRequests/TotalRequests) * 100 for each scenario. How can that be done ?
Scenario | FailedRequests | TotalRequests | Failure Rate |
1 | 203812 | 155791670 | |
2 | 624808 | 485370390 | |
3 | 254167 | 207866254 | |
4 | 664216 | 554088592 | |
5 | 272122 | 237420471 | |
6 | 376757 | 332183915 | |
7 | 364878 | 324435318 | |
8 | 194305 | 173150964 | |
9 | 368061 | 331386374 | |
10 | 368316 | 338115418 | |
11 | 375209 | 365627412 | |
12 | 374385 | 379569936 | |
13 | 114799 | 126844354 | |
14 | 105820 | 161852867 |
Solved! Go to Solution.
@reetu_k add new column
Failure Rate = DIVIDE(Table1[FailedRequests], Table1[TotalRequests])
go to modelling page and select this new column "failure rate" and change it to %.
In above expression change table name and field name as per your data model.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@reetu_k add new column
Failure Rate = DIVIDE(Table1[FailedRequests], Table1[TotalRequests])
go to modelling page and select this new column "failure rate" and change it to %.
In above expression change table name and field name as per your data model.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |