Forum Discussion

mrleijzer's avatar
mrleijzer
Helper I
6 years ago

USERELATIONSHIP not working correctly

Hello all,   I have two tables, Calendar and Projecttakken. There's a main active relationship between Calendar[Date] and Projecttakken[Boekdatum]. There's also an inactive relationship between C...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi mrleijzer ,

 

Thank you for your additional information, could you please try to use the following measure?

 

Measure =
CALCULATE (
    COUNT ( Projecttakken[Boeknummer] );
    FILTER (
        ALLSELECTED ( Projecttakken );
        Projecttakken[Gewijzigd] IN FILTERS ( 'Calendar'[Date] )
    );
    Statussen[Statuscategorie] = "Vervallen"
)


Best regards,

 

mrleijzer's avatar
mrleijzer
Helper I
6 years ago

Thanks Dong Li, but it's still coming up blank.