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,

 

Keep it simple if you add the colum you need in your visual and chosse quick calc the Power BI will allow you to add the % over grand total,

 

Regards Mfelix

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

This is what my visual looks like currently, if I try and add a quick calc to the green line and calculate as % of grand total it gives me this :

 

 

Or if I do it the other way around I get a flat line also - the green line should be a % of the black line

 

Thanks for your patience :)

 

Voose

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago
    The 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
  • Voose's avatar
    Voose
    Icon for Helper III rankHelper III
    9 years ago

    Hi MFelix,

     

    So I want Days worked to be a % of Total working days by month for exmaple in this picture you can see that April is about 80% and in June its around 40%, I could like to see that on a single line graph,

     

     

    Does that make sense? I shouldn't have 2 values on the graph, just 1 and that 1 value should be the % of these two against each other

     

    Thanks

     

    Voose

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

    Hi MFelix,

     

    Just nailed it with a line graph but using a measure that divides one against the other :) thank you for your help! and appretiate your patience.

     

    Thanks

     

    Voose

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

    Makes sense but that is different make a column that divides total days worked by total working days then format as % and use it in your chart.

    Mfelix