TOTAL SUM OF TARGET PER MONTH

[RanHo]

Good day Guys!

Need some help, I have a table here:

and I want to get the total target of team per month  and show at as a column.

Thanks in advance!

[v-stephen-msft]

Hi @RanHo ,

Did you want one of the following results?

You can download the attachment to check.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RanHo]

@v-stephen-msft 
Not like that Sir, i want to achieve the TOTAL TARGET of TEAM per MONTH and then use it as TARGET IN LINE CHART. I will give an example. I want to show it like this wherein the total Target of Team per Month is the Green so that i can compare it with actual data i have.

[v-stephen-msft · Accepted solution]

Hi @RanHo ,

The effect that can be achieved is this. Put the actual value and target value into the column value.

Or you can create a measure to calculate the difference between the actual value and the target value.

Or you can manually add a constant line in Analytics, but this line is a fixed value.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RanHo]

@v-stephen-msft  I'll try it Sir , this might work as alternate.

[Ashish_Mathur]

Hi,

How have you calculated the target value of 15?  Is that the calculated average of all 12 months or is that a figure which already appears in your data?  Also, share the download link of your PBI file. 

[RanHo]

@Ashish_Mathur  The 15 is only example, yes Sir I want to get the total target of Team for 12 months which is I cant get.

[Ashish_Mathur]

I had also requested for a download link of your PBI file.

[Jihwan_Kim]

[RanHo]

@Jihwan_Kim 
Not this Sir,  the thing I want to achieve Sir the total of target per Month base on my example data.

[amitchandak]

@RanHo , Based on what I got .

Matrix visual - Month on Column, nothing on rows

Sum of Target as values

If needed use property - Show on row - On

[RanHo]

@amitchandak 

What if I want to use the target per month in Line Chart and want to compare it with the score per team? I think it will not work. Do I need to make a measure?

[amitchandak]

@RanHo , You can take team on rows. and You can use sum of target as measure

[RanHo]

@amitchandak 

This is the example I want to achieve Sir , is it possible?

[RanHo]

unfortunately Sir, not working for me. How can I get the total sum of target per month using dax?