topic Return True when the row in Column is True and if the row is selected by a slicer. in DAX Commands and Tips

Return True when the row in Column is True and if the row is selected by a slicer.

Anonymous — Thu, 15 May 2025 08:37:22 GMT

Hello,

I have a little problem, where I cannot seem to find the answer to.

I have one table with all the Information in it, and in that Table is a Column, that has TRUE or FALSE values in it. Further there is an ID Column, that is used in a Slicer.

Now to the Problem. I want to show in a Table all the vaules that are marked TRUE plus the values, that are selected in an ID slicer.

So I expect the following Result when ID 2 & 3 are selected in the Slicer:

ID	True/False Colum	Expected Result
1	True	True
2	True	True
3	False	True
4	False	False

I tried it with some versions of the following code but I cannot get it to work:

ShowRow = VAR Always = SELECTEDVALUE('OfflineExcel'[AV_Marked]) = TRUE() VAR IsSelected = CONTAINS( VALUES('OfflineExcel'[Av_Text_Combined]), 'OfflineExcel'[Av_Text_Combined], SELECTEDVALUE('OfflineExcel'[Av_Text_Combined]) ) RETURN Always || IsSelected

And there can be syntax errors in that Code, because of frustration I deleted the DAX 😅 and I recreated it here out of memory.

Thanks and best regards

Lars

Re: Return True when the row in Column is True and if the row is selected by a slicer.

bhanu_gautam — Thu, 15 May 2025 08:53:19 GMT

Anonymous , Try using

DAX
ShowRow =
VAR Always = 'OfflineExcel'[True/False Column] = TRUE()
VAR IsSelected =
COUNTROWS(
FILTER(
ALLSELECTED('OfflineExcel'),
'OfflineExcel'[ID] = EARLIER('OfflineExcel'[ID])
)
) > 0
RETURN Always || IsSelected

Re: Return True when the row in Column is True and if the row is selected by a slicer.

Anonymous — Thu, 15 May 2025 09:09:43 GMT

Hello Bhanu,

thanks for the Quick rsponse. However, if it is a measure, it does not work, since earlier is not a measure object. And when I tried it in a new Row I get the full amount as true which should which should not be the case.

Thanks

Lars

Re: Return True when the row in Column is True and if the row is selected by a slicer.

johnt75 — Thu, 15 May 2025 10:11:22 GMT

You will need a separate, disconnected table to use in the slicer. You can create one with something like

Table for Slicer = DISTINCT( 'Table'[ID] )

Do not connect the new table to the main table.

Now you can create a measure like

Show Row = IF ( SELECTEDVALUE ( 'OfflineExcel'[AV_Marked] ) || SELECTEDVALUE ( 'OfflineExcel'[ID] ) IN VALUES ( 'Table for slicer'[ID] ), 1 )

Add that as a filter to your table or matrix visual, set to show only when the value is 1.

Re: Return True when the row in Column is True and if the row is selected by a slicer.

Anonymous — Thu, 15 May 2025 10:33:56 GMT

Hello John,

Thanks for your response as well. However, this also does not work. The Problem now is, that when the table and the Slicer interact with each other, and in the slicer a row is selected, only that row is shown in the Table. It should show that value and all the others marked true.

When I turn of the interaction, the all the values are shown, and the slicer does not work.

Re: Return True when the row in Column is True and if the row is selected by a slicer.

johnt75 — Thu, 15 May 2025 12:21:54 GMT

That's why you need the disconnected table for the slicer. Making any selection in the slicer should not affect the table at all, unless you place a measure filter on the table.

To be clear, the slicer needs to use the disconnected table, the table visual should use values from the main table.

Re: Return True when the row in Column is True and if the row is selected by a slicer.

Anonymous — Thu, 15 May 2025 12:44:45 GMT

Thank you, John, for the Answer, that did Work 👍