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
What is my dax calculation to get percentage on the table below first line should be 26.4%?
3541/13388
Solved! Go to Solution.
Hello,
Percentage = DIVIDE(SUM([Handset]), SUM([Insurance]), 0)
then format as percentage
Hi @bhavick360 , please use the below measure
Percentage = DIVIDE(SUM(Table[Insurance],SUM(Table[Handset]),0)
Format the above measure as %
Thanks,
Jai
Proud to be a Super User! | |
Hello,
Percentage = DIVIDE(SUM([Handset]), SUM([Insurance]), 0)
then format as percentage
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |