Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |