Forum Discussion
Missing value after sort by column
Hello, My table contains the value and I added 4 more items with formula using - Var .... Return Switch (4 items I want to put), because otherwise 4 calculated formula won't show up in the table....
https://www.sqlbi.com/daxpuzzle/unexpected-filter-behavior-in-calculate/solution/
This is the solution for measure values becoming blank or incorrect when we sort a column by another column
To fix the issue we need to include all(column name which is used to sort by)
So if Column A is sorted by Column B,
Our measure should include
calculate( expresession, filter criteria, all(ColumnB))
Hope this helps someone 🙂
This is a fantastic solution. Thanks a lot. Not even AI tools like Copilot and Gemini was able to crack this