Forum Discussion
Borrek
6 years agoFrequent Visitor
ALLSELECTED on Calculated Column not working
Hi, I tried to find the solution to my problem for over a while. Unfortunately without success. I do have payments statuses in my database that are not properly formatted for end user. So I ...
- 6 years ago
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
6 years agoFrequent Visitor
Hi, thanks for answering but this eliminates all filters - I need to eliminate only payment status filter.
What is wired that the only difference between working and not working formula is the column. If I use column imported from database (and change legend in chart respectively) it works. If I change both to calculated column (SWITCH function on imported column) it does not.
I read about shadow filter so I also tried to insert both columns in ALLSELECTED but it does not work as well.