Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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-...
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/1447...