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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
