Removing Filter Context to Calculate Total Value for Market Share

[Fraze]

Hello,

I am having some serious issues with this problem. All I want to do is remove the effect of two filters, and use that as the total for a market share calcualtion.

Here are my filters:

Slicer - Data[Location]

Slicer - Data[Date]

Slicer - Date[Model]

Filter on Visual- Date[Transaction Type]

Filter on Visual - Date[New/Used]

These filters take my count of rows from 2938 to 266. What I want to do is remove the effects of the Slicer - 'Model' and 'Visual Filter - Transaction Type', which would increase the count of my rows to 1018. This is the number I need to calculate market share with. 

Market Share Numerator = COUNT(Data[Deal#])

Market Share Numerator = ??

I have been trying to use the functions All(), ALLEXCEPT(), REMOVEFILTER(), etc., but I either get errors, the wrong number or a number that does not adjust when I drill down from year to quarter. Total Market = CALCULATE(COUNT(Data[Deal#]),.....

Help would be greatly appreciated.

Frazer

[v-jayw-msft]

Hi @Fraze ,

Try ALL(Date[Model],Date[Transaction Type]), better to share some sample data to us.

Best Regards,

Jay

[Ashish_Mathur]

Hi,

Share a simple dataset, describe the business question and show the expected result.

[amitchandak]

@Fraze , is disabled interaction is an option for this case?

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Fraze]

Hi @amitchandak 

Unforunatly that will not work in this case - interesting read though, ill have to try that - as I need all the filters to be applied so a user can navigate to the level they need to.  Need to find a way to calculate the sum from a high filter context.