Forum Discussion
Static Measure Changing when a slicer is filtered
This requires more information before it can be solved. (what fields are in the visual, what tables they come from?).
--
From a visual inspection, there may be a problem with the filtering since there is a many-to-many relationship there (which we don't like).
Also, when measures are written with a CALCULATE, it's going to affect context and I would ask "why is it there?". Sometimes people have a gut instinct to add CALCULATE to measures. It may be valid, it may not but it may be part of the problem here.
--
In summary, remove the CALCULATE unless you need it, re-examine the model and think about how you want filtering to work here.
Community ChampionThis requires more information before it can be solved. (what fields are in the visual, what tables they come from?).
--
From a visual inspection, there may be a problem with the filtering since there is a many-to-many relationship there (which we don't like).
Also, when measures are written with a CALCULATE, it's going to affect context and I would ask "why is it there?". Sometimes people have a gut instinct to add CALCULATE to measures. It may be valid, it may not but it may be part of the problem here.
--
In summary, remove the CALCULATE unless you need it, re-examine the model and think about how you want filtering to work here.
The many-to-many relationship was 100% the issue!! I created a new table with the business request type and related it to the default_1 and Static Capacity tables.
Genious! Thank you so, so much! Really appreciate you taking a look!