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
mrleijzer's avatar
mrleijzer
Helper I
6 years ago

Hey thanks for the quick replies!

 

Unfortunately they didn't solve the problem.

It's so weird, I've checked all the filters (there's really only one active on the Calendar[Date] field) and it keeps on coming out Blank.

 

I also tried running the operations in different orders, I've tried the FILTER function but it's no use.

Triple checked the relationships and it all looks good.

 

I'll keep trying, meanwhile, if you have any brilliant ideas, let me know ;)!

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    6 years ago

    Is it possible to share your PBIX? (only if there is no confidential data in it). If preffered, you could PM me a link if you don't want to share publicly.

    • mrleijzer's avatar
      mrleijzer
      Helper I
      6 years ago

      Unfortunately, RM&C won't allow me to share this report / data.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Hi,

    Share the link from where i can download your PBI file.  Tell me the exact visual/card where you want to see 39 but are unable to see.