Forum Discussion

amtbew's avatar
amtbew
Icon for Helper I rankHelper I
2 years ago
Solved

Conflicting Results from Dim Table Calculated Column

I'm trying to add a column to a dim table that checks to see if a certain type of spend is present in my fact table. I'm getting incorrect info back and not sure what the reason.   I have a simple ...
Need Help
  • nsexton12's avatar
    nsexton12
    2 years ago

    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!

nsexton12's avatar
nsexton12
Icon for Resolver II rankResolver II
2 years ago

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. 

nsexton12's avatar
nsexton12
Icon for Resolver II rankResolver II
2 years ago

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!