Forum Discussion
Solved
Remove visual filter context
Hi, I want that whatever the value I click in the table on the left, the red card on the right show the min value of the slicer above. I wasn't able to make it work cause it shows me the clicked va...
FADAVI Retry with:
RedCard_Value :=
VAR MinSlicer =
CALCULATE(
MIN('Table'[Date]),
ALLSELECTED('Table'[Date]) // keep slicer, ignore table click
)
VAR Clicked =
SELECTEDVALUE('Table'[Date])
RETURN
IF(
HASONEVALUE('Table'[Date]),
Clicked, // when user clicks in table
MinSlicer // when nothing clicked
)
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
VAR Clicked =
SELECTEDVALUE('calendar'[Date])
Will not give me the min but the actual clicked value
And your first var is the one I originnaly used
CALCULATE(
MIN('calendar'[date]),
ALLSELECTED('calendar'[date])
)