Forum Discussion
SELECTEDVALUE, HASONEVALUE not Recognizing Small Multiples
I don't think that there will be any way to get this working with small multiples. If you look at the DAX queries generated for the visual, when the measure for the constant line is evaluated it is done in an evaluation context which does not include the column you use to separate the small multiples, so because it is not being filtered at all there is no way to determine which multiple you are currently in.
My guess is that this is by design for performance reasons. As it is a constant line then the categories should have no impact on its value, and it is only calculated once for the entire visual, rather than having to be calculated multiple times when it should produce the same value.
I don't think that there will be any way to get this working with small multiples. If you look at the DAX queries generated for the visual, when the measure for the constant line is evaluated it is done in an evaluation context which does not include the column you use to separate the small multiples, so because it is not being filtered at all there is no way to determine which multiple you are currently in.
My guess is that this is by design for performance reasons. As it is a constant line then the categories should have no impact on its value, and it is only calculated once for the entire visual, rather than having to be calculated multiple times when it should produce the same value.
I think you are correct, but that seems like a weakness in the design to just assume the small multiple doesn't affect the constant. In this case the constant line does differ based on the small multiple, the point is to showmultiple versions of the same analysis with a slightly varying assumption represented by the line.
I've moved to just making individual visuals with a locked filter.