1 of 1 people found this helpful
Not certain I understand the total issue but you had the ref line set to the state parameter for the X avg which will return a constant value - resetting it to the Agg fro the calculated field will return a 0 when Bihar is filtered out of the data
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim! @
Attaching the updated workbook and clarifying the issue -
Basically, the idea is that if no state is selected, the National avg & State Avg line should coincide, and if a state is selected, the state avg line should move accordingly, and when a district is further selected, the state avg line becomes static as well.
From what I have now, with the National & State Ref line linked to calculated fields NatProdLine & StateProdLIne (which uses FIXED : (Geography Level) to calculate that level's avg) in Image below
Issue: When geo filters are de-selected, ideally, the bars and the two ref line should coincide. However, they don't.
Which doesn't make any sense, as the total avg should be 161 for even State Avg (If not filters are active). I can't even locate where this 155 value is coming from.
Let me know if you need me to clarify.