Forum Discussion

GiuseppeMR's avatar
GiuseppeMR
Frequent Visitor
2 years ago
Solved

Dynamically change the Matrix filter

Hi all, I have a PBIX with 2 entities: Sales and Calendar, and there exists an N-1 relationship between these entities. Moreover, the Sales entity has 2 measures, M1 and M2....
Data Protection
  • parry2k's avatar
    parry2k
    2 years ago

    GiuseppeMR first and foremost you need to make some changes to M1. here I have create M1 New that uses the M1 but you can put this logic directly in M1

     

    M1 New = 
VAR __CurrentYear = YEAR ( TODAY () )
RETURN
CALCULATE ( 
   [M1],
   KEEPFILTERS ( 'Calendar'[Year] = __CurrentYear] ) 
)

     

     

    For the selection, you can use a field parameter or calculation groups.

     

     

     

     

     

     

parry2k's avatar
parry2k
Super User
2 years ago

GiuseppeMR first and foremost you need to make some changes to M1. here I have create M1 New that uses the M1 but you can put this logic directly in M1

 

M1 New = 
VAR __CurrentYear = YEAR ( TODAY () )
RETURN
CALCULATE ( 
   [M1],
   KEEPFILTERS ( 'Calendar'[Year] = __CurrentYear] ) 
)

 

 

For the selection, you can use a field parameter or calculation groups.