Forum Discussion
win rate with filter
Hello PBI Community, I have the current win rate formula but would like to constrain it (via formula) to only those opportunities that are above $1,000,000. I can then compare it to our ...
HI Anonymous,
If you want to keep the original filter effects on your formulas, I'd like to suggest you use allselected function replace all. (notice: all function will ignore current filter effects)
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng