Forum Discussion
Total Calculation with multiple fact Table
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 Thanks a lot for such a quick response. I am not entirely sure how I can implement your suggested solution. There is no one table that I can summarise. Measure come from 3 different tables: factMetrics, factTurnover and factGroup.
How can I use summarise function in this case?
You can summarize across common dimensions.
or Use one fact in summarizing and common dimesions and the measure from other tables.
amitchandak I do not know how I can summarise across the common dimensions. Could you please help me with the formula?
Summarise function is used for one Table as far as I know.
I cannot use one fact in summarising, because in the real data model none of the facts contain a full list.
The file can be found here: FileI 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.