Forum Discussion
Total is wrong for DIVIDE function
Hello. I am not able to get the total for this formula to accurate total. The column I’m referring to is LostRevYTDSUM. It should be $10,934 and not $7,718. I have shown the detail to the left. I won...
Try this:
LostRevYTDSum = SUMX ( VALUES ( ParentPartnerMonthlySales[ParentPartnerID] ), [LostRevYTDSumCalc] )I figured it out. Thank you for the suggestion. I just started trying all the columns. 🙂 Appreciate it
I would need to see your data model. Be sure to remove sensitive data before uploading the pbix. You can use one of the file services such as OneDrive and post the link here.
unfortunately its connected to a server. Not sure how Id recreate it.