why my sales target amount for every GROUP are same figure ?

[Paulyeo11]

Hi All

My Target Amount is correct before add the YTD Sales :-

My target amount is wrong when i add YTD Sales :-

Not working PBI File , This was create by me  :-

https://www.dropbox.com/s/kael3b5ibmk9vi4/PB_TDS_V030%20ASK.pbix?dl=0

Working PBI File , This was created 1 week ago still working :-

https://www.dropbox.com/s/gmk0l4htc4buheq/TARGET_V010%20Final%20SOLUTION%20MASTER%20WORKING%20FINE.p...

Hope some one can advise me where go wrong ? I have Try to link all the table.

Paul Yeo

[v-yuaj-msft · Accepted solution]

Hi @Paulyeo11 ,

There seems to be an error in the relationship you established between the 'TARGET' table and the 'Source & Group' table.

(right relationship)

Hope that's what you were looking for.

Best Regards,

Yuna

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

[amitchandak]

@Paulyeo11 , you have taken the group from the sales table. Take it from the common table. Find the file attached after the signature.

[Paulyeo11]

Hi Amit

Thank you very much for your help as usual.

I have try to using GROUP from share table or from Target table , i still cannot get it right :-

Hope you can help me check my actual PBI again.

Below is my PBI file :-

https://www.dropbox.com/s/83iukdbkbgl5w66/PB_TDS_V027%20ASK.pbix?dl=0

Paul

[ryan_mayu]

@Paulyeo11 

i think the reason is the group is from sales table not from Souce & group table.