Group the data Values to only show a single line - not multiple data points

[Anonymous]

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 

[amitchandak]

@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

[Anonymous]

HI Amit - How do you summarise by group ID???? can you help please.

[amitchandak · Accepted 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]

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