Forum Discussion
Solved
SUM function doing wrongly calculation
Hi Community..!! Find below screenshot for your information. @@test is measure name, Day column is coming from calendar table and Tot service value gross coming from order level table, both t...
Hi All, Thank you so much for all your inputs and suggestions, my issue has been resolved by simple SUM fucntion, issue was in the data not in the DAX.
Once again thank you so much for your kind help..!!😊
If you want precise help, share two things
The exact DAX for @@test (so I can review it).
A screenshot of the Model view showing the relationship between your Calendar and Orders.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Jaywant Thorat | MCT | Data Analytics Coach
Linkedin: https: https://www.linkedin.com/in/jaywantthorat/
#MissionPowerBIBharat = https://shorturl.at/5ViW9
Hi Jaywant-Thorat
measure is just i am using
SUM('Order Level Details'[Tot. Service Value Gross])
Calendar table and order level table are connected via calendar_sk and relation is one-many single direction.
Calendar table and order level table are connected via calendar_sk and relation is one-many single direction.