Forum Discussion
Helper IIUser 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 that there is a way for the user to pick "YES", or "NO" under the variable USERINPUT variable.
Then I need the following:
DAX =
IF( USERINPUT = "YES",
........,
........ )
These values are not slicers and can not be used as slicers.
Please let me know your thoughts.
Thanks,
CK
CK1992 , You can create an independent table with values Yes and No and use that to measure
if(selectedvalue(Table[Column]), "Yes", [Measure], blank())
1 Reply
- amitchandak
Super User
CK1992 , You can create an independent table with values Yes and No and use that to measure
if(selectedvalue(Table[Column]), "Yes", [Measure], blank())