Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
4 years ago
Solved

Measure Filter Can No Longer Be Edited

I created a measure that I use as a filter on several visuals on a page to filter for the selected value. It now has a warning icon next to it and I can't change it but I'm unsure why. Any Ideas?

 

in the filter pane:

 

In Field pane:

 

measure: 

Sales Play Selected = if(SELECTEDVALUE(Customers[Sales Play])=values(SalesPlayGroupings[Sales Play]),1,0)
  • Hi, astano05 

     

    Can you see the error message?

    'Values' function returns a single column table, 'SELECTEDVALUE' function returns one value.

    VALUES function (DAX) - DAX | Microsoft Docs

    An error occurs when the context of values() has an empty or multiple value result, you can check it.

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

1 Reply

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, astano05 

     

    Can you see the error message?

    'Values' function returns a single column table, 'SELECTEDVALUE' function returns one value.

    VALUES function (DAX) - DAX | Microsoft Docs

    An error occurs when the context of values() has an empty or multiple value result, you can check it.

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey