Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Expert
See sample PBIX File
I not sure how to group the data point so i only see on value for Inbound Freight, Duty and SC&L People and so on as opposed to multiple line as per PBIX File...
https://www.dropbox.com/s/n8xp2pm7pypvehp/PLP_Test_2%20%281%29.pbix?dl=0
Solved! Go to Solution.
@Anonymous , I right-clicked on it, i visual pane, and used count, You can use min max.
Or create a measure
Count(Table[Group ID])
concatenateX(Table, Table[Group ID])
@Anonymous , In the second table, you have group ID, which is not summarized. That is why values are more than once for new_reporting_header
HI Amit - How do you summarise by group ID???? can you help please.
@Anonymous , I right-clicked on it, i visual pane, and used count, You can use min max.
Or create a measure
Count(Table[Group ID])
concatenateX(Table, Table[Group ID])
Hi Amit - if you do that it do not give values for Inbound freight, duty and SC&L People and so on.... kindly try it in the pBIX
User | Count |
---|---|
96 | |
87 | |
78 | |
73 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |