Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have tried to use SUM to add up the column values in each row and the final value is not right
My formula is as follows:
This is driving me crazy. Any help would be appreciated.
Luis
Solved! Go to Solution.
Thanks for sharing the PBIX. First off; try updating your PBI desktop (it doesn't relate to this issue, but always good to be up to date as I got a compatibilty message 🙂 )
Then on to your issue. The Key column has it's summarization set to COUNT, not SUM:
If this is correct, you need to change your measure accordingly:
Totals = COUNT('Outstanding Work'[Key])+SUM('Outstanding Work'[Verify])+SUM('Outstanding Work'[Submit])+SUM('Outstanding Work'[1ST TRACK])+SUM('Outstanding Work'[2ND TRACK])+SUM('Outstanding Work'[Outstanding HDMs])
Result:
Let me know if this answers your question 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Hi Djerro,
I dont know why you see count. This is my desktop capture...
Are the other columns just column references or are these measures? If they are measures, could you share them? If they are column references, would it be possible to share your PBIX (can also via PM if you don't want to share publicly)? There is definitely something funny going on but we have to little to go on here 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
no the data is not a measure but it is in a matrix
I dont want to share publicly and I didnt see an attachment option in the pm section
Regards,
Luis
Thanks for sharing the PBIX. First off; try updating your PBI desktop (it doesn't relate to this issue, but always good to be up to date as I got a compatibilty message 🙂 )
Then on to your issue. The Key column has it's summarization set to COUNT, not SUM:
If this is correct, you need to change your measure accordingly:
Totals = COUNT('Outstanding Work'[Key])+SUM('Outstanding Work'[Verify])+SUM('Outstanding Work'[Submit])+SUM('Outstanding Work'[1ST TRACK])+SUM('Outstanding Work'[2ND TRACK])+SUM('Outstanding Work'[Outstanding HDMs])
Result:
Let me know if this answers your question 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Hi Djerro,
I dont know why you see count. This is my desktop capture...
The number in your matrix represents a COUNT of the Key column, not a SUM. This is confirmed when you clik on the little arrow in the Columns field of the visual like the screenshot above. Changing your measure to use COUNT for the calculation as well for the Key column fixed the issue for you (now you get 172 in the first row). I don't know if you need COUNT or SUM, that is up to you of course.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
If they are column references, do the value represent distinct counts? Or are they number columns and are they summarized as sums?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |