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
v-lionel-msft
6 years agoCommunity Support
Hi Borrek ,
Or try this.
DIVIDE(
[SalesValue],
CALCULATE(
[SalesValue],
ALLEXCEPT( Oders_table, Oders_table[payment_type_switch] )
)
)
If the problem is still not resolved, please provide sample data and screenshotes of the visual.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.