Forum Discussion
Why does a sorting column affect DAX measures?
- 21 days ago
Hi,
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.
Hi afaherty,
Yes, Sort by column can affect the filter context used by a Power BI visual. Power BI internally needs both Description and Order Sort in the query so it can display the descriptions in the required order. So if your percentage measure removes only the filter from Description.
Please find the attached pbix file with a solution for your scenario. Please let me know if you hae any further questions. Thanks.
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X