Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I've looked this one up and know it will be some sort of divide function, but I am having trouble getting a measure to fit in when writing it. Below I would need each instance of the row labels in the Bridge Column divided by the total actuals (2.1) in a percentage. Once again, I assume this is easier than it appears, but I cannot get the formula to work for me. Thanks!
Solved! Go to Solution.
@Anonymous , Try using below DAX
Percentage of Total =
DIVIDE(
SUM('YourTable'[Bridge Column]),
CALCULATE(SUM('YourTable'[Bridge Column]), ALL('YourTable'))
) * 100
Proud to be a Super User! |
|
@Anonymous , Try using below DAX
Percentage of Total =
DIVIDE(
SUM('YourTable'[Bridge Column]),
CALCULATE(SUM('YourTable'[Bridge Column]), ALL('YourTable'))
) * 100
Proud to be a Super User! |
|
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 18 | |
| 10 | |
| 9 | |
| 7 | |
| 7 |