Forum Discussion

Voose's avatar
Voose
Icon for Helper III rankHelper III
9 years ago
Solved

Bring one total column from a table into another

Hi Guys,   Feel like I have a basic question here but just unsure how I can get this done in my head. In one table i have my target utilisation by region and by Month:   Target Utilisation Re...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi Voose,

     

    Try to make a ID column in each of the table composed by region and month, them do a relation between the two table with that ID and you can the make a Column or use the values from the two table directly.

     

    the Column will look something like this 

    Column = CALCULATE(SUM(Target[Target Utilisation]);RELATEDTABLE(Target))

    Regards

     

    MFelix 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi Voose,

 

In the related you can only refer to the table not a colum so you formula should be:

 

Target Utilisation = calculate(sum('Summarised Tables Month Ultilisation'[Target Utilisation]),RELATED('Summarised Tables Month Ultilisation))

You are already refering to the column you want in the sum function.

 

MFelix

Voose's avatar
Voose
Icon for Helper III rankHelper III
9 years ago

Hi MFelix,

 

Am now using  -> Target Utilisation = calculate(sum('Summarised Tables Month Ultilisation'[Target Utilisation]),RELATED('Summarised Tables Month Ultilisation'))

 

Still having the same error message... unsure why, i have a bi-directional 1-1 relationship in the model as well.

 

Thanks 

 

Voose