A problem of interaction

[Anonymous]

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

[MFelix · Accepted solution]

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]

Thank you so much 🙂