Forum Discussion
DAX Measure Calculation – Returning Empty Values
toum
i tried to replicate demo on my side (next time just add data in csv format instead of image, it will be much easier).
I have a few questions and checks
1) calculations for min and max selected date are correct
2) format of your measure looks like it is actually calculated column, not measure?
Example: CALCULATE(
SUM(tab[sales]),
tab[START DATE] <= [minselecteddate],
In measure this returns error as tab[Start date] needs to have some kind of aggregation.
If you created it as a measure, please send full Dax for the measure.
3) if you created it as calculated column, then changing slicer (date) will have no impact on this calculated column because calculated column is "older" than slicer. It is created/calculated before slicer. Slicer has impact on measure, but not on calculated column.
Attached results of each condition (pbix and screenshot). I couldn't find any date period where all conditions are met.
Cheers,
Nemanja
- toum1 year agoHelper II
Thank you a lot for your help
- yes the minselecteddate and maxselecteddate measures works fine, I get the correct dates
- Yes it's a measure not a calculated column