Forum Discussion
Deneb - measure totals not showing correct value
Hi,
I have an issue with a deneb visual which is not showing the measure values properly.
It calculates the rows seperately split by descriptions and then adds them together which is a different out come.
Example:
This is how it should be:
ID | Count hours | Total Units | Out come |
1 | 10 | 92 | 9.20 |
What happens is:
ID | Count hours | Total Units | Out come |
1 | 5 | 47 | 9.4 |
1 | 8 | 45 | 5.625 |
this totals 15.025
It counts some hours double as it considers the description (there are 4 descriptions). So you can have as 2 descriptions in 1 hour, so it doesn't count it as 1 but as 2.... When I remove "Description" from the visual values, the measure shows correctly, but I need the "Description" so removing it is not an option.
To fix this I wanted to use transform, but this allows me only to use in on one measure and not on two...
The below doesn't work.
"transform": [ { "aggregate": [ { "op": "sum", "field": "Count of Hours", "as": "totalHours" } ], "groupby": ["ID", "Other ID"] } ], "transform": [ { "aggregate": [ { "op": "sum", "field": "Total Units", "as": "totalUnits" } ], "groupby": ["ID", "Other ID"] } ]
With the standard power bi visuals I don't have this problem... but those limit me with the visual I want to create
If somebody knows what can be done to fix this or has another way to solve this issue that would realy be appriciated.
Thanks in advance.
1 Reply
- lbendlinSuper User
You should be able to solve that as a measure.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523