Chart Not Filtering Properly

[Anonymous]

Hi,

I am new to PBI and seek some guidance.

Please refer to the data model below.

 

Note that I had to create a bridge table called EmployeeEmail to join PBI_Event and Employee because otherwise it's Many to Many relationship.

I would like to analyze number of days from today each user/employee was last active.

For this, I created two measures:

LastActivity = CALCULATE(MAX(PBI_Event[CreatedDateUtc+10 - Date]))

InactivePeriodDays = VALUE(CALCULATE(TODAY() - [LastActivity]))

Then, using this measure in stacked bar char as per below.

It seems to be working OK, but when I tried to filter the chart to only include active employee using [Employee].[EmployeeStatus] in the Visual Level Filter, the chart generates wrong data (see below).

Similarly, if I put EmailAddress in Visual level filter, and just choose an email address, it does not filter the chart to only show that user, so looks like the filtering does not work properly.

I am not sure why this occurs. Is it in the measure calculations and/or the data model relationship or something else that I miss?

Any advice is appreaciated.

[v-chuncz-msft · Accepted solution]

@Anonymous,

Drag measure [LastActivity] to visual level filter and set Show items when the value is not blank.