Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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
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,
Henry
As 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.
@tranje , Please share the measure. It may be because of row context
refer video from Curbal
https://www.youtube.com/watch?v=ufHOOLdi_jk
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
share your Dax please
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
83 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |