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,
I have created table to count WO Assignee Group ticket. The data was taken from different tab sheet in excel.
I managed to count total ticket for "Previous Ticket" table using the following measure:
Previous Ticket = COUNT('Previous WO Raw Data for Ageing'[WO Assignee Group])
but not success for Latest Ticket table using the following measure:
Latest Ticket= COUNT('Latest WO Raw Data for Ageing'[WO Assignee Group])
it looks like the number of tickets count for each group is the same
Anyone can help me what is wrong?
Thanks
Solved! Go to Solution.
Hi @Zaky
As tested, if "Previous WO Raw Data for Ageing" table and "Latest WO Raw Data for Ageing" table have no relationship, it shows all the same value for "Latest Ticket" measure,
To solve this, i create relationship between two tables with "many" to "many" relationships.
(as there are duplicates in 'Previous WO Raw Data for Ageing'[WO Assignee Group] and 'Latest WO Raw Data for Ageing'[WO Assignee Group] )
If you have any problem, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zaky
As tested, if "Previous WO Raw Data for Ageing" table and "Latest WO Raw Data for Ageing" table have no relationship, it shows all the same value for "Latest Ticket" measure,
To solve this, i create relationship between two tables with "many" to "many" relationships.
(as there are duplicates in 'Previous WO Raw Data for Ageing'[WO Assignee Group] and 'Latest WO Raw Data for Ageing'[WO Assignee Group] )
If you have any problem, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
Amazing! I managed to applied accordingly.
Thanks for your help
Regards,
Zaky
Hi,
I noticed that there is no many to many option. How can i add one?
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 |
---|---|
117 | |
101 | |
69 | |
69 | |
43 |
User | Count |
---|---|
146 | |
106 | |
104 | |
89 | |
65 |