Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

A problem of interaction

Hello community,

 

I need your help

 

I have two table one is user the other is date

I have two relationships one is active between date_contract_end and actual_date(date table)

and inactive relationship date_contract_start and actual_date(date table)

 

I create a clustred column chart and a table to know the name of new and exit users

for the clustred column chart I select count(user_id) for the exit entry number and create a measure calculate(count(user_id),userelationship( date_contract_start,actual_date(date table)))

 

The problem is when selecting the exit entry column it shows me the name of users but when selecting the new entry number it shows me the same name of exit entry

 

here is some screenshots to clear more the situation

 

 

When selecting the exit number it shows me correctly the names:

 

But when selecting the new entry it shows me the name of exit entry, there is no interaction

 

Thanks in advance

  • Hi Anonymous ,

     

    What I did was to create an unrelated table with the values start and end then created the following measure:

     

     

    Chart Values = 
    SWITCH (
        TRUE ();
        SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "Start"; [Entry];
        SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "End";
            CALCULATE (
                DISTINCTCOUNT ( USERS[user_id] );
                FILTER ( USERS; USERS[date_fin_ctrt] <> BLANK () )
            );
        DISTINCTCOUNT ( USERS[user_id] )
    )

     

    Now just make your chart with following strucure:

    • Axis - Calendar[Month]
    • Legend: Measure_Selection[Measure]
    • Column Values: [Chart Values]

    Then add the [Cart Values] to the table visualization and hide it.

     

    Check PBIX file attach.

     

     

     

2 Replies

  • Hi Anonymous ,

     

    What I did was to create an unrelated table with the values start and end then created the following measure:

     

     

    Chart Values = 
    SWITCH (
        TRUE ();
        SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "Start"; [Entry];
        SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "End";
            CALCULATE (
                DISTINCTCOUNT ( USERS[user_id] );
                FILTER ( USERS; USERS[date_fin_ctrt] <> BLANK () )
            );
        DISTINCTCOUNT ( USERS[user_id] )
    )

     

    Now just make your chart with following strucure:

    • Axis - Calendar[Month]
    • Legend: Measure_Selection[Measure]
    • Column Values: [Chart Values]

    Then add the [Cart Values] to the table visualization and hide it.

     

    Check PBIX file attach.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much 🙂