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

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