Forum Discussion

babaci's avatar
babaci
Regular Visitor
3 years ago

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