Forum Discussion
Subtotal is not correct (sum up ) in matrix
Hi
Somehow the matrix (column) is not sum up correctly, it shows the average value or something.
Thank you in advanced for your help.
Best regards,
Jenny
7 Replies
- mh2587
Super User
share your Dax please
The total number of tests is based on powerbi distinct count
What I changed:
Subtotal is showing on the top and it has a band row style
- amitchandak
The total number of tests is based on powerbi distinct count
What I changed:
Subtotal is showing on the top and it has a band row style
v-henryk-mstfCommunity Support
Hi tranje ,
Does it display properly after the change? Also what is the value shown for total weekly? What is the corresponding measure formula for it?
Looking forward to your feedback.
Best Regards,
HenryAs you can see in the picture (The "Total weekly" is not sum up correctly).
Actually, I did not use any DAX, I used the count distinct. What I did change is the formatting.
All the configuration for formatting you can see in the answer I gave to the others.
Hi
The described problem could not be solved.
The matrix cannot sum up correctly for "total weekly"
No DAX used. Just the simply funtion from PowerBI (count distinct)
The question is why it does not sum up.
I have a feeling that it counts distinct instead of summing up.If it is doing so....how can I make it summing up?
Best regards,Jenny
