topic Ignore measure when slicer is selected in DAX Commands and Tips

Ignore measure when slicer is selected

RJ_KON — Mon, 11 Mar 2024 18:00:57 GMT

Hi Community, I would like my measure in table to ignore when slicer is selected.

Below is my measure which is calculating previous month income based on week ranks and is showing blank when slicer is selected

Last period Income =

VAR CW= MIN('Calendar'[WeekRank])

VAR Cal1 = CALCULATE([SalesIncome],'Calendar'[WeekRank]=CW+148,
REMOVEFILTERS('Calendar'[Financial Week]))

RETURN Cal1

My slicer is using calendar financial week column

Thank you in advance for any suggestions/advices.

govindarajan_d — Mon, 11 Mar 2024 18:18:01 GMT

In your formula, you need to apply the filter for CW variable as well:

VAR CW = CALCULATE(MIN('Calendar'[WeekRank]),REMOVEFILTERS('Calendar'[Financial Week]))

RJ_KON — Mon, 11 Mar 2024 19:20:41 GMT

Hi Govindarajan, it worked.

Thank you