topic Re: Check if rows are selected in DAX Commands and Tips

Check if rows are selected

Anonymous — Thu, 10 Mar 2022 17:07:50 GMT

Hello guys,

I have a single Table that records sales transcations for "Products". In my dashboard there are slicers (for "Region" and "Product") that select a certain subset out of my list of transcations. For this subset, I want to check if the rows are selected.

Suppose, I slice for "Product B" and "Europe". Then the column IsSelected would look like in the table below.

How would you create the column IsSelected?

Thanks in advance!

Product	Region	Price	IsSelected
A	America	3	0
A	Europe	2	0
B	America	20	0
B	Europe	18	1
B	Europe	21	1
B	Europe	17	1

Re: Check if rows are selected

amitchandak — Thu, 10 Mar 2022 18:08:00 GMT

Anonymous , if they (slicers) are from the same or connected table then

if(isblank(countrows(table)) ,0,1)

Re: Check if rows are selected

Anonymous — Fri, 11 Mar 2022 07:58:17 GMT

amitchandak This command gives back a column with ones everywhere, although the slicers are connected to the table. This approach doesnt work for me

Re: Check if rows are selected

amitchandak — Fri, 11 Mar 2022 08:05:17 GMT

Anonymous ,Try like

If( Max(Table[Product]) in allselected(Table[Product]) && Max(Table[Region]) in allselected(Table[Region]) ,1, 0) +0

Re: Check if rows are selected

Anonymous — Fri, 11 Mar 2022 09:30:18 GMT

It still doesn't work. Maybe the following would help me understand and solve it:

I assumed that ALLSELECTED('table') returns the rows of 'table' that are selected by the slicers. Instead, it returns the entire table. It that normal?

Re: Check if rows are selected

Anonymous — Wed, 16 Mar 2022 07:55:52 GMT

Hi Anonymous ,

You will need to create two independent slicer tables and use them as slicers.

slicer_p = DISTINCT('Table'[Product])

slicer_R = DISTINCT('Table'[Region])

Then create a measure as below.

Measure = IF(SELECTEDVALUE('Table'[Product]) in VALUES(slicer_p[Product])&&SELECTEDVALUE('Table'[Region]) in VALUES(slicer_R[Region]),1,0)

Best Regards,

Jay