Forum Discussion
Policy Retention
Hello Everyone, I've been stuck quit a while with this and I'm pretty sure there is a simple way to do these but I've always struggle with filters. Data sample pbix: https://1drv.ms/u/s!AqZ-...
Hi orlandopowerbi,
>>I would like to keep slicing capability of the TenureStartYearMonth (only Year) and PolicyType fields, since the users will be slicing those fields.
I'd like to suggest you take a look at the following blog to use allexcept to replace all functions to exclude specific filter effects.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng