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.
ignas ,
Multiplication needs to be sum(A*B). As we already have aggregated columns, We need to get the correct row context. You need to change the group by in summarize to force calculation at the correct row level
I added three of them
sumx(summarize(Table,Table[Name],table[Month], table[Segment],"_1",[Target+control Size],"_2",[AVG Target turnover]),[_1]*[_2])
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.