Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have created a Matrix which shows the Count of responses for each possible answer to a number of questions. I've then used the built in functionality in Power BI Desktop to display the same measure as a percentage of the row total. But the problem is it shows it to 2 decimal places, and I need it to be displayed with 0 decimal places.
I understand this is not available and therefore I need to create a calculation to acheieve this, but I dont know what that calulation should be.
This is the measure I used to get the Count -
Solved! Go to Solution.
Sorry for my late reply. here you go:
Measure = DIVIDE([S&B_Count],SUMX(FILTER(ALLSELECTED('Metadata-S&B'),'Metadata-S&B'[Question] in FILTERS('Metadata-S&B'[Question])),[S&B_Count]))
Pbix attached.
When you create the measure, did you try to modify the number of decimal places in the format panel?
I didnt create the measure -I just used the functionality to show a measure as a % of the row total, like this:
In order to do as you've suggested I need to make a measure for it, but I dont know what the calculation would be.
I just tested it on my side, and found the same issue as yours, I'd suggest you raise it as an issue in the portal:
https://community.powerbi.com/t5/Issues/idb-p/Issues
But there's a workaround to fix it by creating a measure, you might consider share the dummy pbix that I can draw it up for you.
Sorry for my late reply. here you go:
Measure = DIVIDE([S&B_Count],SUMX(FILTER(ALLSELECTED('Metadata-S&B'),'Metadata-S&B'[Question] in FILTERS('Metadata-S&B'[Question])),[S&B_Count]))
Pbix attached.
Thanks for your help.
I want to replicate the "% of Row Total" calculation as a measure so that I can remove the decimal places.
I've got a dummy Power BI report, but I cannot see where to upload it!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |