Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Set measure value based on slicer selection

Good afternoon   I would be grateful for some help with the following issue. I have 2 measures Cardcount and Cardpos, which I think I need to make act like two variables and I do not know how. I ...
  • TomMartens's avatar
    3 years ago

    Hey Anonymous ,

    I have to admit that I do not fully understand what challenges you have to tackle.

     

    No matter, if you are using a slicer based on the column focus you can use this snippet to create two variables in every measure that you want to "react" on the slicer selection

    some measure = 
    
    var selectedConv = SELECTEDVALUE( 'Table'[Conv] , BLANK() ) //provide a default value or consider making the focus slider a single selection
    var selectedposit = SELECTEDVALUE( 'Table'[Posit] , BLANK() ) //provide a default value or consider making the focus slider a single selection
    return
    
    SWITCH(
        TRUE()
            , selectedConv = "Higher" && selectedposit = "Lower"
                , 1 //put you measure definiton here
            , selectedConv = "Higher" && selectedposit = "Higher"
                , 2
            , selectedConv = "Lower" && selectedposit = "Higher"
                , 3
            , selectedConv = "Lower" && selectedposit = "Lower"
                , 4
    )

    You are not restricted to use SELECTEDVALUE with the column that is used on a slicer, the default value is fired when more than one value is selected inside the slicer or none (meaning all).

     

    Hopefully, this provides an idea on how to tackle your challenge.

     

    Regards,

    Tom