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.
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.
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.
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.
