Forum Discussion
Solved
Total Calculation with multiple fact Table
I cannot make changes in Data Model, so I hope there is a possibility to calculate correctly totals in measure. Data model: It is a simplified version of a real model. Correct Absolute Tu...
I created it like this.
Absolute Turnover Target_Control = sumx(SUMMARIZE(factGroup,dimName[Name],dimMonth[Month],dimSegment[Segment],"_1",[Target+control Size],"_2",[AVG Target turnover]),[_1]*[_2])and corrected datatype. it coming 14.48. Can you explain how it should be 15.
File attached.
I created it like this.
Absolute Turnover Target_Control =
sumx(SUMMARIZE(factGroup,dimName[Name],dimMonth[Month],dimSegment[Segment],"_1",[Target+control Size],"_2",[AVG Target turnover]),[_1]*[_2])
and corrected datatype. it coming 14.48. Can you explain how it should be 15.
File attached.
amitchandak You saved my day. It was a bit too difficult for me, but now I have learned. Highly appreciated.
By the way, how are you able to attach the file?
I cannot find this button.
I am a superuser. Superuser, superpower 😀