Forum Discussion

ignas's avatar
ignas
Advocate II
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    ignas 

    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's avatar
ignas
Advocate II
6 years ago

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: File 

amitchandak's avatar
amitchandak
Super User
6 years ago

ignas 

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's avatar
    ignas
    Advocate II
    6 years ago

    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.

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      I am a superuser. Superuser, superpower 😀