Forum Discussion
Helper IConflicting 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!
Resolver III know it is not usually recommended, but could you change your relationship to many-to-many and see if that fixes your issue? It looks like a relationship problem at first glance. If not, please let me know and I will test alternative solutions.
Please mark as a solution if this worked for you!
amtbewI tried Many to Many and it didn't change the outcome.
- nsexton12
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").- amtbew
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.