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 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
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 |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |