Forum Discussion
Names grouping together - unwanted
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.
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.
