Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :-
Hope some one can advise me where go wrong ? I have Try to link all the table.
Paul Yeo
Solved! Go to 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.
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.
@Paulyeo11 , you have taken the group from the sales table. Take it from the common table. Find the file attached after the signature.
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
i think the reason is the group is from sales table not from Souce & group table.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |