Forum Discussion
yharfush
6 years agoFrequent Visitor
Measures using ALLEXCEPT and slicers
Hello, I am having trouble using an ALLEXCEPT measure that takes into account the slicers I have placed on my report. My table has different Vehicle penetration by state, the table contains t...
- 6 years ago
That's because your ALLEXCEPT removes all other filters except the ones that you specify. Try adding your other columns into your ALLEXCEPT function.
Greg_Deckler
Community Champion
6 years agoThat's because your ALLEXCEPT removes all other filters except the ones that you specify. Try adding your other columns into your ALLEXCEPT function.
yharfush
6 years agoFrequent Visitor
Ah yes this works! Thank you :)!!