Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter Interaction from Matrix Not Working As Expected

I have a measure that shows a specific date for a location when a table is filtered:

 

IF(
    ISFILTERED(organization_view),
    SELECTEDVALUE(organization_view[OTR_Conversion_Date_Format])
)

 

What I want is to be able to click a Site in a Matrix and have a card update showing the date returned from the above measure. This works when I filter using a Table visual:

 

But it does not work when filtering using the Matrix (where I need it to work) due to a Time Intelligence column being used.

 

 

 

Both the table and Matrix are using the same Site_id field from the same table. When I remove the visual filter for Time Intelligence, it works from the Matrix. I also noticed when I put the Time Intelligence Filter on the page, it breaks the measure on the report.

 

 

I have tried using:

CALCULATE(
    IF(
        ISFILTERED( organization_view ),
        SELECTEDVALUE( organization_view[OTR_Conversion_Date_Format] )
    ),
    REMOVEFILTERS('Time Intelligence'[Time Intelligence])
)

But this does not work.

 

Anyone have any ideas? Thank you in advance!

No Replies