How to make REMOVEFILTERS or ALL work in this scenario?

[RingoMoon]

My measure looks like this

CALCULATE(
COUNTROWS(VALUES(Metrics[Sales Area])),
REMOVEFILTERS(Metrics[Metric])
)

And my data looks something like this:

Sales Area	Metric
Area 1	Metric A
Area 2	Metric B
Area 1	Metric B
Area 2	Metric C
Area 1	Metric C

If I put Sales Area in a slicer and select Area 1 and Area 2 together with the metric unfiltered I get 2 as a value in the card but if I have it filtered to Metric A, I get 1 as a value. How do I make it so that I get the unfiltered metric value which is 2 even if I have Metric A selected in the slicer? REMOVEFILTERS didn't seem to work in this case.

Sample pbix

REMOVEFILTERS.pbix

[Kaviraj11 · Accepted solution]

Hi, 

You can use edit interaction features to disabled the interactions between visuals:

Change how visuals interact in a report - Power BI | Microsoft Learn

[parry2k · Accepted solution]

@RingoMoon I don't think any of these solutions work, except @Kaviraj11 ones which is to disable the interaction and the core reason for auto exist, google it or watch this video. Auto Exist - Importance of star schema in Power BI. Why ALL function doesn't work? (youtube.com)

[MNedix]

@RingoMoon 

Plenty of options to choose from. Aside the solutions provided by @Kaviraj11 and @rajendraongole1 you can also try

M1 = CALCULATE(
COUNTROWS(VALUES('Metrics'[Sales Area])),
FILTER(ALL('Metrics'),'Metrics'[Metric]<>BLANK())
)

Cheers,

[Kaviraj11 · Accepted solution]

Hi, 

You can use edit interaction features to disabled the interactions between visuals:

Change how visuals interact in a report - Power BI | Microsoft Learn

[rajendraongole1]

Hi @RingoMoon - can you try below modified logic

CALCULATE(
COUNTROWS(VALUES(Metrics[Sales Area])),
REMOVEFILTERS(Metrics[Metric]),
ALL(Metrics[Metric])
)

Hope it works.