Forum Discussion
Countrows giving improper aggregation
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1)You can create a masure.
Measure = SUMX( 'filter_date' , [Deliveries at Normal Level all days attempt_v1])(2)Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your description, you are showing the wrong value in the Total of the visual object.
First of all, you should be using a metric value, which is not simply summed when calculating Total, but calculates your corresponding metric formula based on the current filtering context, so the resulting value does not match your expected value.
You can use the following methods to avoid this situation.
(1) Using iterative functions such as SUMX() to calculate the value.
(2) Use calculated column to calculate the value you want and then put it in the visual object.
(3) Use the HASONEVALUE() function to replace the Total value you want.
For more information you can refer to the following links:
Calculated Column and Measure in Power BI (powerbiconsulting.com)
Power BI DAX SUM and SUMX function - How to use - EnjoySharePoint
HASONEVALUE function (DAX) - DAX | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.