Forum Discussion
ALLSELECTED on Calculated Column not working
Borrek , try removefilters
removefilter(Table[payment status])
refer example on
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
Borrek , try removefilters
removefilter(Table[payment status])
refer example on
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
The problem was that ALLSELECTED should be not only imposed on payment_type calculated column but also calculated column that was used to sort payment_type column.
Not sure why but sorting by other column affected contex filters of column I used. I was able to find it by removing filters.
From my point of view such situation is counterintuitive but this is how it works.
I also found this worked; when I included 2 ALLSELECTED statements, one for the dimension and the other for the column I was using to sort the dimension (used to sort the legend in a bar chart). Slight difference to yours is that in my case they were both were held in a separate reference table with a relationship on a calculated column in the main dataset.
