Names grouping together - unwanted

[DataDork]

I have some baseball data that I am reviewing.  With the dataset there are a unique identifier and the full name.  I would like to use the full name, however power bi rolls them up together so players with the same name get large sums.  Is there a way to use two columns in the Axis to keep the records unique or will I have to group these together on name and id then somehow use DAX to extract the ID portion of the string.  If that would even work......

Thanks for any assistance.  

I even tried to pull in another excel file creating and one to many off the key and use the player name from that table but it still rolls it up.  

[dilumd]

HI @DataDork

go to your value field and select "don't summarize".

click on the drop down after field name

[DataDork]

@dilumd

I'm not really seeing the options like that.  

I have two basic fields.  Values and Axis which in this case would be Player Name.  In order for me to keep it unique without Power BI rolling up the names is to use the unique ID.  

I there a way to build a measure to prevent grouping like that.  I know in SQL if you did that, it would group by and roll the names, but you could add the UID to the query and that would prevent the merging of the individuals name due to the nature of the grain.....

Here is a screenshot.  

[DataDork]

Some additional failed experiments......

Tried to apply the playerID, the UID to the report level to break up the aggregation.....   

Concatenate the fields and then tried breaking off the end of the field in the Axis......

Created a proper 1:M join on the ID  using the playerID between the datasets and then using the Dim table to pull in the players name, but it still rolls it up. 

I attempted to create a hierarcy in the Axis, attempting to force the application to recognize the UID with the player name but it still rolls up.  This is really silly behavior in the application.  You would think you could at the very least control the grain of the data on the Axis with nesting another measure or some setting.......   I'm beginning to see this as a severe limitation in Power BI.  

[Anonymous · Accepted solution]

Dear DataDork,

Please try this.

- Create new Column: User =  CONCATENATE(  CustID  & " - " , CustName)

- Create new Calculate: count order = CALCULATE(DISTINCTCOUNT(OrderNumber) , ALLEXCEPT(User)

- Remember add the column "User" in your report.

Reagards,

ManNVSM.

[dilumd]

Hi @DataDork

Is it possible for you to add index column at the query level and then concatenate index column and the name column?