Multiple conditions ... my query

[Thangavel_Raju]

I would like to further say that the amount should not be hard coded but should be a cell reference.

Thanks

[v-luwang-msft · Accepted solution]

Hi  @Thangavel_Raju ,

You could sete Parameter . If you want to achieve it refer the below article:

https://community.powerbi.com/t5/Desktop/Conditional-Filter-based-on-multiple-parameters-in-Power-Qu... 

And if you dax ，you could use What if parameter to create a dynamic value ,refer the below sample:

https://community.powerbi.com/t5/Desktop/Use-parameters-to-create-conditional-columns/m-p/841393 

Best Regards

Lucien