Forum Discussion

TotunG's avatar
TotunG
Icon for Resolver I rankResolver I
3 years ago
Solved

How to reference a slicer in formula

Measure = VAR SelectedValue = SELECTEDVALUE('Slicer Name') RETURN COUNTROWS(FILTER('Table','Table'[Date] = SelectedValue))   The above measure isn't working for me. I'm testing to write it into ...
General Comment
Need Help
Show and Tell
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi TotunG ,

     

    The Syntax for SELECTEDVALUE  is :

     

    SELECTEDVALUE(TableName[ColumnName] ) or 

     

    SELECTEDVALUE(TableName[ColumnName], Alternative Result ) Alternative Result comes when multiple or no value is selected in column.

     

    So you need to put the table and column which you put into the slicer you want to refer to.

     

    SELECTEDVALUE-Funktion - DAX | Microsoft Learn

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi TotunG ,

 

The Syntax for SELECTEDVALUE  is :

 

SELECTEDVALUE(TableName[ColumnName] ) or 

 

SELECTEDVALUE(TableName[ColumnName], Alternative Result ) Alternative Result comes when multiple or no value is selected in column.

 

So you need to put the table and column which you put into the slicer you want to refer to.

 

SELECTEDVALUE-Funktion - DAX | Microsoft Learn

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

jens_S's avatar
jens_S
Regular Visitor
10 months ago

That's a good explanation how the SELECTEDVALUE function works, but it's not the answer to his question: "How to reference a slicer in formula?" 

Hence, the answer to the question would be: "you don't!" or rather you can't directly reference a slicer. BUT!!!

 

You can create an options table containing the slicer's future options. The this new table is linked in a 1:n relationship with the data table you need filtered. The slicer is linked to your newly created options table. This way you can address the options table with selectedvalue AND filter the data table.

Hope that helps 🙂