Forum Discussion
Conflicting Results from Dim Table Calculated Column
I figured out your issue. Since you have that formula in a calculated column, it is not being filtered by the filters you have on the page. This is because the result is calculated in the data model instead of on the page. So, if you delete your calculated column, use that DAX code in a measure, and then drag that measure into your DIM visual, it will work.
Please mark as a solution if this answered your question!
I recreated your data in my file and it all worked properly. Maybe it is the syntax of your calculated column?
I am not sure why you have Calcs[Spend-Category 1] when it is just a measure. Can you try just typing in [Spend-Category 1]? My calculated column was: IF([Measure 1] > 0 , "true","false").
My measure is in a measure table called Calcs.
I tried moving the measure out of that table and referencing it like you said and it still returns the same result.
Can you scrub sensitive data and attach your PBIX file? I can't recreate your issue on my end and will need to see your full file unless someone else sees an error.
I figured out your issue. Since you have that formula in a calculated column, it is not being filtered by the filters you have on the page. This is because the result is calculated in the data model instead of on the page. So, if you delete your calculated column, use that DAX code in a measure, and then drag that measure into your DIM visual, it will work.
Please mark as a solution if this answered your question!