Forum Discussion
show values for all
Hi Ania26 ,
Not really sure if I understand what you want to achieve but if you replace the ALL by ALLSELECTED you will get the values based on the filter/values applied meaning that if you are at market level you will get that specific market value if you are at any other level you will get the total values for the selected markets.
If this is not the expected outcome please elaborate a little bit more on the result and if possible share a mockup file and expected result.
Hi Ania26 ,
Straightforward option could be to create two measures each for its own intended purpose, the original measure above would be Out_Total and a base version of the measure that lets the filter Destination Market flow through will be a Out_Market measure. And it could even be modified as:
OUT_Market =
CALCULATE(
[(CC) Volume Estimates],
'EPS Data_CIGARETTES_BASE'[*** Domestic Indicator] = "Non-Domestic",
'EPS Data_CIGARETTES_BASE'[Year] = 2025
)
OUT_Total =
CALCULATE(
[OUT_Market],
ALL('EPS Data_CIGARETTES_BASE'[Destination Market])
)I believe you had applied the ALL for a certain intent such a KPI card or something for which you had to modify the filter context to block any filter coming in for the Destination market. Again, in another visual, you want the filter for the same field to come through but that such a conditional turning on or off of a filter context cannot be cleanly achieved so this approach might be a maitainable one.
Hope it helps!