Forum Discussion
ALLSELECTED doesn't work with FILTERS
How can ALLSELECTED work when I filter a value included in one of the measures required to calculate the percentage? Number of Visits # Visits = CALCULATE(SUM(Main[VALUE]),ALL(Main[OrderCode]), ...
Using ALL would aggregate the numbers in the roll up level. You can't see that in the sample above, but if you add dates (which is what I have in my real report), you'll be able to see the issue. Is there another option?
v-juanli-msft
Community Support
Community SupportCould you show me some example dataset which will effect the result you want for better analysis?
Best Regards
Maggie