Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Is there a simpler solution for what I think is a simple problem?
Problem: I have a matrix table with three categories at row level and around 5-6 measures. For the measures where there were decimal points rounted to 0, the total is miscalculated. As an below example: Notice the last column is in decimals.
Department# employees% expectedActual
Sales | 61 | 0.4 | 24.4 |
Marketing | 3 | 0.6 | 1.8 |
Finance | 2 | 0.6 | 1.2 |
HR | 1 | 0.2 | 0.2 |
Total | 27.6 |
When I make the decimals 0, I get below: Notice the total. It should have been 27. To calculate the % I did use Sumx(Master,(# employees * % expected)). Is there a simple way of achieving this. I did follow this blog but I have way too many measures to incorporate the changes. I'm looking for a cleaner solution if that's even possible.
Department# employees% expectedActual
Sales | 61 | 0.4 | 24 |
Marketing | 3 | 0.6 | 2 |
Finance | 2 | 0.6 | 1 |
HR | 1 | 0.2 | 0 |
Total | 28 |
thank you!
Solved! Go to Solution.
Hi @PoojaG
Incorporate the rounding within your sumx formula and not just in the formatting. That should be something like
Sumx(Master,round(# employees * % expected),0))
Proud to be a Super User!
Hi @PoojaG
Incorporate the rounding within your sumx formula and not just in the formatting. That should be something like
Sumx(Master,round(# employees * % expected),0))
Proud to be a Super User!
If you want the result to be 27 then you need to implement your own integer math.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |