Filter in measure is not applying

[cristianml]

Hi,

For some reason the filters is not applying on the visual:

'00_CALENDAR'[Current XTD]=

Testing:

Filter not applied:

Filter applied:

Any idea why the filters in the measure is not doing what is expected to do ?

Thanks!

[cristianml · Accepted solution]

I solved this issue creating another measure using the filters again :

-Visual 2 (Card) (Var %) Switch =

VAR _Period = SELECTEDVALUE(Period[Period])

VAR _PTD = CALCULATE('PTO - MM-ME'[-Visual 2 (Card) (Var %)],'00_CALENDAR'[Current PTD]="PTD")

VAR _MTD = CALCULATE('PTO - MM-ME'[-Visual 2 (Card) (Var %)],'00_CALENDAR'[Current MTD]="MTD")

VAR _QTD = CALCULATE('PTO - MM-ME'[-Visual 2 (Card) (Var %)],'00_CALENDAR'[Current QTD]="QTD")

VAR _YTD = CALCULATE('PTO - MM-ME'[-Visual 2 (Card) (Var %)],'00_CALENDAR'[Current YTD]="YTD")

RETURN

SWITCH(_Period,

"MTD",_MTD,

"PTD",_PTD,

"QTD",_QTD,

"YTD",_YTD)

The issue is that sometimes is not applying the filters due to the order of the variables. I learned that if you create the variables with the filters before the calculation it works.

[lbendlin]

Have you considered using Field Parameters or Calculation Groups for this scenario?

Examine your data model, especially the search filter directions.