Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a matrix with 1 row and 1 column and several values. RunningSum is correct in each of the row groups, BUT not in the Total Row Group. In the Total row Group, it is showing the total from the LAST row group. Below is the measure; I suspect the problem is related to the "Call Type Set" condition. PLEASE Help. Way below is a picture of the Results.
Solved! Go to Solution.
Hi @SewardExelon ,
You can create another new measure as below and put this new measure to replace the original measure [RunningSumOffered] onto the table visual as below screenshot...
Measure = SUMX ( VALUES ('HVDN table call volume(main)'[Call Type Set] ), [RunningSumOffered] )
In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
If the above one can't help you get the desired result, please provide some sample data in your table 'HVDN table call volume(main)' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi @SewardExelon ,
You can create another new measure as below and put this new measure to replace the original measure [RunningSumOffered] onto the table visual as below screenshot...
Measure = SUMX ( VALUES ('HVDN table call volume(main)'[Call Type Set] ), [RunningSumOffered] )
In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
If the above one can't help you get the desired result, please provide some sample data in your table 'HVDN table call volume(main)' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Yingyinr - THANK YOU! Your first solution worked - I'm so happy that you helped me - it saved me alot of time. Also, thanks for the other links. These will help me to improve my DAX skills.
Check this blog post, might be helpful:
https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn | Twitter | Blog | YouTube
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
107 | |
97 | |
39 | |
32 |
User | Count |
---|---|
153 | |
122 | |
77 | |
74 | |
44 |