Forum Discussion
Row total is wrong when filter is selected.
Hi All,
The utilization for the bleow (image 1) is correct when client name is ALL and when I select particular client the utilization goes down because the baselien hours aggregates (Image 2). Let me know any workaround.
Baseline hours (measure) = days worked*working hours.
Utilization = billable hours/Baseline hours*100
Image 1
Image 2
Hi , Anonymous
There are many cases of this phenomenon,like this:
(1)The calculation of the measure value is calculated according to the current filter context, and when you select a value in the slicer, the value will be returned in Total with the current filter context.
(2)The calculation of Total also needs to be judged in combination with the relationship between tables.
For your problem, you can try using SUMX for calculations.You can also provide your sample data and the output data you want (.pbix or table) so that we can help you better.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
Hi , Anonymous
There are many cases of this phenomenon,like this:
(1)The calculation of the measure value is calculated according to the current filter context, and when you select a value in the slicer, the value will be returned in Total with the current filter context.
(2)The calculation of Total also needs to be judged in combination with the relationship between tables.
For your problem, you can try using SUMX for calculations.You can also provide your sample data and the output data you want (.pbix or table) so that we can help you better.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly