Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have face an error ordering, I can handle how to resolve the ordering issue
but I can find which table and column that must fixed. The condition is I have a lot of table and column in my dataset
The error message said:
Cannot order 'Query1 (2557772)'[Column (4258683)] by [Index (4255204)] because at least one value in [Column (4258683)] has multiple distinct values in [Index (4255204)]. For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region.
is there any clue what column is pointed by that number
Thank you
Solved! Go to Solution.
Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.
Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
52 | |
31 | |
24 | |
18 | |
15 |