Forum Discussion
Anonymous
3 years agoNot applicable
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