Forum Discussion
Use Whole Number from Parameter for Calculated field
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
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