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

Thanks!

 

Using your formula PowerBI says that the column Statussen[Statuscategorie] either doesn't exit or doesn't have a relationship in de current context.

 

Below an image of the two tables and how they're related (both decimal number format).

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.

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi mrleijzer ,

       

      Where are you applied the 'Date'[Date] column, in the table visual or in the filter? We can try to use the following measur if you use it in the filter:

       

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

       

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

       


      Best regards,

       

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi mrleijzer ,

       

      How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


      Best regards,

       

      • mrleijzer's avatar
        mrleijzer
        Helper I
        6 years ago

        Sorry for not replying earlier.

        I don't use filters, everything is filtered in measures.

        I tried your calculations nevertheless but this also didn't work. Thanks for the suggestion.