Forum Discussion
afaherty
Helper V
Helper VWhy does a sorting column affect DAX measures?
I have had this issue happen to me many times over the past few years and I don't understand it, so I was hoping someone else might! Let's say I have a table of student grades: Studen...
Jihwan_Kim
Super User
Super UserHi,
when the description is not sorted by the sort order column, and when run the visualization's dax query view,
the DAX query does not contain sort order column, so the measure does not need to include sort order column.
However, when the description column is sorted by the sort order column, then you query it,
then, the query contains sort order column, even the visual does not show sort order column, so in this case, measure need to contain this sort order column as well.