Forum Discussion

boraJustmop's avatar
boraJustmop
Frequent Visitor
3 years ago

Changing Filtered Field Dynamically in Dax

Hi ,    I'm having a problem that I have been trying to solve for a while. I ve been keep searching for the solution but I m not sure if there is a solution. Let's go through from a simple example...
boraJustmop's avatar
boraJustmop
Frequent Visitor
3 years ago

Thank you so much for your answer and efford. 

 

I can't use field parameter because I will not use create_date and start_date as dimension. I will put Country, City or other fields as dimensions and want to show how many appointments created 12th December 2022  and how many appointments started on the same day based on used dimensions. 

 

That is why I definitaley need to change dax formula dynamically. This is easy to do in Qlik but I couldn't find a way to do it in PowerBI. 

 

Thanks 

Oguz