Ignore measure when slicer is selected

[RJ_KON]

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.

RV

[govindarajan_d · Accepted solution]

Hi @RJ_KON,

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

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

[govindarajan_d · Accepted solution]

Hi @RJ_KON,

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 · Accepted solution]

Hi Govindarajan, it worked.

Thank you

RV