Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filtering Issue Many to many Relationship date Table

Hi Experts   See model below (image) - I am using date_day from 02 | Calendar table as a date between filter and Products from dev_con_hcp_universe table - but i am unable to filter the matrix tabl...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    Try this.

    Measure =
VAR EndConsentdate =
    MAX ( '02 | Calendar'[day_date] )
VAR StartConsentdate =
    MIN ( '02 | Calendar'[day_date] )
RETURN
    IF (
        SELECTEDVALUE ( dev_con_consent[capture_day_date] ) <= EndConsentdate
            && SELECTEDVALUE ( dev_con_consent[expiration_day_date] ) > StartConsentdate,
        1,
        0
    )

     

     Best Regards

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

Try this.

Measure =
VAR EndConsentdate =
    MAX ( '02 | Calendar'[day_date] )
VAR StartConsentdate =
    MIN ( '02 | Calendar'[day_date] )
RETURN
    IF (
        SELECTEDVALUE ( dev_con_consent[capture_day_date] ) <= EndConsentdate
            && SELECTEDVALUE ( dev_con_consent[expiration_day_date] ) > StartConsentdate,
        1,
        0
    )

 

 Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Many Thanks