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 ,

 

We can try to use the following measure to meet your requirement:

 

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

 

If it does not work, could you please describe the relationship between Projecttakken and Statussen tables simply if it does not contain any confidential information?

 


Best regards,

 

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,