Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Dear all,
How to calculate percentage column, for below image:
And this is the measure used to calculate the table above:
Count LStatus =
COUNT(Table2[Latest Status])
Thanks in advance for your help and assistance.
Prima Indonesia
Solved! Go to Solution.
Hi @Anonymous,
You can use:
% = [Count LStatus] / CALCULATE([Count LStatus],ALL('Table'))
Then format the measure as percentage.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI
Dear Shaurya,
Cool ! It works !
Thank you so much, problem solved.
Again, thank you.
Prima Indonesia
Hi @Anonymous,
You can use:
% = [Count LStatus] / CALCULATE([Count LStatus],ALL('Table'))
Then format the measure as percentage.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 8 | |
| 8 | |
| 7 |