Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Check if rows are selected

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 tra...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,Try like

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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?