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.
