The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.