Forum Discussion
Use Whole Number from Parameter for Calculated field
Hi All,
I created a vey basic numeric parameter with slicer on the visual with values from 1 to 30. If nothing selected 3 is pre-selected.
The parameter value changes when using the slicer which is all good.
Now I am trying to use the value in an Dax formular :
The issue the formular is not picking up the slicer / parameter value but stays consistent at 3.
I tried using[DelayDaysValue Value] in dax directly as well as creating another measure in the dataset.
The measure will pick up the correct value but once used for the above what if calculation doesnt work.
I am confused. Can somebody pls help explain me whats wrong?
Is your DAX formula a calculated column? If so, that's the reason the parameter value stays at 3. Calculated columns are unable to recognize user-specified filters (Report view). You'll need to create a measure instead.
Hi Malcolm ,
Thank you for reaching out to Microsoft Fabric Community Forum.
DataInsights Thank you for your prompt response.
I’ve attached a sample Power BI (.pbix) file that demonstrates the solution using sample data.
Please have a look and let me know if this helps clarify the approach. Feel free to tweak it to fit your actual dataset and let me know if you run into any issues or need further help!
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
5 Replies
- DataInsights
Super User
Is your DAX formula a calculated column? If so, that's the reason the parameter value stays at 3. Calculated columns are unable to recognize user-specified filters (Report view). You'll need to create a measure instead.
Hi Malcolm ,
Thank you for reaching out to Microsoft Fabric Community Forum.
DataInsights Thank you for your prompt response.
I’ve attached a sample Power BI (.pbix) file that demonstrates the solution using sample data.
Please have a look and let me know if this helps clarify the approach. Feel free to tweak it to fit your actual dataset and let me know if you run into any issues or need further help!
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara ReddyHi Malcolm ,
Hi @,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hi Malcolm ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hi Malcolm ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
B Manikanteswara Reddy