Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

User Input is not recognized in DAX formula

Hi all,   I am a newbie and want to create a report with different sets of criteria, based on user input. The input value appear fine on the dashboard and in the report table but in formulas, it se...
General Comment
Need Help
Tips and Tricks
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

Try to test the below:

Step1,create silcer table for per:

Then use the  below:

test1 = SWITCH ( TRUE (),
 (SELECTEDVALUE('Table'[source])= "VW1"&& SELECTEDVALUE('Table'[PER])<= SELECTEDVALUE(preslicer[preslicer])), [measure1],
 ( SELECTEDVALUE('Table'[Source])= "VW2"&&SELECTEDVALUE('Table'[PER]) = SELECTEDVALUE(preslicer[preslicer])) ,  [Measure2] , 0 )

return:(return value according measure1 ,and measure)

 

You could download my pbix file if you need.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Lucien,

 

Thank you kindly for your help. I am currently on vacation but as soon as I get back to work, I will try out right away your suggestion.

 

Very much appreciated.

Daniel