Hello!
I am having issues having the sum for a column add correctly. In the screenshot below you will see that the total by month for 2 separate buying groups are the same. I am using the matrix table and I run into the same issue when viewing the data by week and month.
I tried searching the forum and changing the format type of the LE column, but I am not getting the correct sum. Could you please let me know what I need to adjust in my data. I am including a link with a file. I changed the data for security reasons.
Thank You!
Hi @Greg_Deckler thank you for your response! Below are the relationships I created. Is there anything else I should connect?
@mpw Looks like a missing relationship.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Hi @Greg_Deckler thank you for your response! Below are the relationships I created. Is there anything else I should connect?
Helpful resources
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
| User | Count |
|---|---|
| 94 | |
| 92 | |
| 84 | |
| 83 | |
| 49 |
