Forum Discussion

Euro0681's avatar
Euro0681
Icon for Helper II rankHelper II
3 years ago
Solved

Measure Calculations??

So maybe this is a simple question to you guys, but if I have a "Page Level Filter" on a report will my measure take that filter into consideration before starting it's calculation??  Also, another ...
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Using ALLSELECTED will take it into consideration, at the level you specify in the function. Keep in mind ALLSELECTED is a complicated function and should be used carefully.
    I suggest taking some time to read the following post to get a better understanding.

    ALLSELECTED 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Euro0681 The page filter will pre-filter the context for the measure, so it will not be going through all 60,000 suppliers essentially, just whatever happens to be in the filter context at the time the measure calculates. If you don't want to sum the null values (not that it would impact the result, then you could do:

SUMX(FILTER('Table',[Value] <> BLANK(), [Value])

 

This will add additional filter context to whatever is being passed by the page filter, visual filters and any cross filtering going on between visuals.