1 of 1 people found this helpful
This is hard to answer without seeing the actual workbook. Can you attach it to your post?
If that is not an option I have a few questions:
- Is [Count - Increasers] a measure? If so, how is it being aggregated?
- Is [Amount - Change Base to Comparison] being aggregated in your table? If so, using what function?
- What is your formula for [Amount - Change Base to Comparison]?
Just a quick question. Are you using any quick filters? Those will impact your calculated fields but "fixed" happens before them.
I dont really understand what you're trying to do and why a lod is needed but that could be an easy fix.
I am using a quick filter and that is what's creating the problem. Thanks for identifying where I was going wrong!
The reason I'm using a lod calculation is because I want a text box on a dashboard that says "Between 2014 and 2016 the amount increased in X municipalities". For the X value I want to use sum(Count - Increasers).
Hopefully I can get everything to work now that I understand the order that filters are executed.
By the way, I found what helped me get the result I want is to add a context filter as it's applied before the LOD.