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
amitchandak's avatar
amitchandak
Super User
6 years ago

You measure seems fine. Try following

 

1) Check any other filter on-page of drilled

2) Create the below measure

Measure1 = CALCULATE(COUNT(Projecttakken[Boeknummer]);USERELATIONSHIP('Calendar'[Date];Projecttakken[Gewijzigd]))

and now a table of matrix drag Statussen[Statuscategorie] and Measure1 

 

Are you able to see the value for Vervallen. If not you can found the issue/