topic Re: Check selected row against Selected values from Slicer in DAX Commands and Tips

Check selected row against Selected values from Slicer

Mahmed1 — Mon, 26 Feb 2024 17:21:11 GMT

im trying to a put a 1 against each row where the the current row matrix interval = the slected values in the slicer (multiple selection rather than single value is possible)

ive tried the below but get a 1 against each row and not the values selected in the slicer

Selected Intervals To Show =

VAR SelectedIntervals =ALLSELECTED(qry_previous_180_days[Revised_Time])

VAR IntervalValue = MIN(qry_previous_180_days[Revised_Time])

RETURN

IF(IntervalValue IN SelectedIntervals,1,0)

Re: Check selected row against Selected values from Slicer

lbendlin — Mon, 26 Feb 2024 22:07:11 GMT

are these tables connected in the data model?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Check selected row against Selected values from Slicer

Mahmed1 — Mon, 26 Feb 2024 22:14:31 GMT

Hi yes they are connected

Infact they are coming from same table

so all i wanted to do is if the current row time in the matrix visual (say 08:00) is = to whats selected in the slicer ie (say slicer selected value is 08:00 and 09:00) then put a 1

the formula for time is coming from same table

Re: Check selected row against Selected values from Slicer

lbendlin — Mon, 26 Feb 2024 22:17:22 GMT

That won't work as they already share the filter context. At a minimum your slicer needs to be fed by a disconnected table.

Re: Check selected row against Selected values from Slicer

Mahmed1 — Mon, 26 Feb 2024 22:18:31 GMT

i dont have access to the file or computer but the result should look like this

Re: Check selected row against Selected values from Slicer

Mahmed1 — Mon, 26 Feb 2024 22:26:08 GMT

Oh ok - so how can i reference the time column from this table but keep it disconnected

i guess then my formula would work right?

Re: Check selected row against Selected values from Slicer

Mahmed1 — Mon, 26 Feb 2024 23:51:16 GMT

Hey i created a disconnected interval table called Time_Disconnected but still get same result (1 against each row)

tried to use offset function to get same row but didnt work as it kept saying maybe duplicate values

Selected Intervals To Show =

VAR SelectedIntervals =ALLSELECTED(Time_Disconnected[Revised_Time])

VAR IntervalValue = MIN(qry_previous_180_days[Revised_Time])

RETURN

IF(IntervalValue IN SelectedIntervals,1,0)