Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need HELP with DAX please!

Hello All   I have a complex request to be able to select a sample of data for auditing based on user-selected dates.   What I want to be able to do is:   Take the Date diff between the User-s...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you v-easonf-msft .I suspect this might be the case. Would be good to enable this feature in the Power BI.