Forum Discussion
Need HELP with DAX please!
Hi, Anonymous
This can be a little difficult if your model involves slicers.
You are using a calculated column instead of a measure, which will cause the result to be static(not recalculated based on your current filter context). If you use measure instead, the result will be correct, but you won't be able to apply it to the 'Axis' on the bar chart.Best Regards,
Community Support Team _ Eason
tackytechtom Well actually, I added a IF statement to deal with the -ve In Weeks figures but it didnt go well for other In Weeks figures.
You can see below, User selected date is 31/07/2021, based on that you can see there should be a range from 0-1 Weeks, 1-2 Weeks, and 2-3 Weeks etc.. but its shows as 0-1 Weeks for all.
This is my Dax code
tackytechtom, not sure if I am missing something obvious, any help would be much appreciated.
Many thanks
Community SupportHi, Anonymous
This can be a little difficult if your model involves slicers.
You are using a calculated column instead of a measure, which will cause the result to be static(not recalculated based on your current filter context). If you use measure instead, the result will be correct, but you won't be able to apply it to the 'Axis' on the bar chart.
Best Regards,
Community Support Team _ Eason