Forum Discussion

CK1992's avatar
CK1992
Icon for Helper II rankHelper II
3 years ago
Solved

User input to be used as a DAX Variable

Hi team,   I hope you are well.   I was wondering if there is a way to create a user input and then use it in my DAX.   Please see the example below.   In the report page of my PBI, let's say...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    CK1992 , You can create an independent table with values Yes and No and use that to measure

     

    if(selectedvalue(Table[Column]), "Yes", [Measure], blank())

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

CK1992 , You can create an independent table with values Yes and No and use that to measure

 

if(selectedvalue(Table[Column]), "Yes", [Measure], blank())