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
I still unable to figure out why my sales vs target still not able to work.
My PBI File :-
https://www.dropbox.com/s/5lsgp4wns4lxpws/PB_TDS_V035.pbix?dl=0
Solved! Go to Solution.
@Paulyeo11 , Create a Key Source+ group in Sale and Target. Added that to source and group dimesnion. Join both tables with dimesion. Used the group from dimesnion.
Check the file attached
If i understood the issue properly please Create a table as shown below
Now join the sales and target table using the group column with this table as shown below
Now use this group table which you have created to show the sales ytd and target YTD measures
Appreciate a Kudos if this resolves your query !!
Hi Jai
I have follow all your step , i still unable to get it link.
And i link the GROUP Table field GROUP_ with sales Table and Target Table.
My PBI file :-
https://www.dropbox.com/s/80b997adcoqkzv8/PB_TDS_V046.pbix?dl=0
Paul Yeo
Hi Jai
Thank you very much. For your detail explain .appreciate very much.
@Paulyeo11 , Create a Key Source+ group in Sale and Target. Added that to source and group dimesnion. Join both tables with dimesion. Used the group from dimesnion.
Check the file attached
Hi Amit
Thank you very much.
I have created all that like what you said , but then still not working . now i see that you make it work . may be you can share with me what you do ?
Paul
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |