Forum Discussion
Voose
Helper III
Helper IIIBring 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...
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
Super User
Super UserThe two line aren't in the same format since one is % and the other total numbers you need to have ine in coluns and the other in line choose the bar and line chart and it will work
Regards
Mfelix
Regards
Mfelix
