Forum Discussion
prasadpatil020
Helper I
9 months agoSUM 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...
- 9 months ago
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..!!😊
Jaywant-Thorat
Super User
9 months agoIf 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
prasadpatil020
Helper I
9 months agoHi 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.