ALL does not ignore the slicer in DAX

[Anonymous]

Hello,

I am struggling with the ALL and FILTER here. I have a report conneting live to Tabular model. 

Data model is like this - 

CarModel                            Details                                                        Date                    Country

ModelName  --------->  ModelName, CarID, Delivery Year                  Year                    CountryCode

                                        ,RetailCountryCD

I want to count the ratio of  "total selected model cars"  to the "toal cars" of that year and country. 

Relationship :  "CarModel" and "Details" tables are connected on "ModelName".  I have a slicer with "ModelName" from" CarModel " table. Another slicer is with "CountryCode"

I have a matrix where Year is used as column and shows the ratio.

Var selectedyear = SELECTEDVALUE('Calendar'[Year]; 0 )

var selectedcountry = SELECTEDVALUE(Country[CountryCode])

this seems not working as ALL does not ignore the ModelName slicer.

var cp = CALCULATE( COUNT(Details[CarID]); Details[Delivery Year]= selectedyear ; Details[RetailCountryCD]= selectedcountry)

var cptotal = CALCULATE( COUNT(Details[CarID]); Details[Delivery Year]= selectedyear ; Details[RetailCountryCD]= selectedcountry; ALL(Details[ModelName]))

Please help how to ignore the slicer in this formula as seems ALL has no impact it still has ModelName filter applies as cp/cptotal is calculated to 1.

I observed that in this formula ALL works - var cptotal = CALCULATE( COUNT(Details[CarID]); ALL(Details[ModelName]))

but not in above with Year and Country filters.

Regards

Madan

[Greg_Deckler]

Can you share sample data and what you want to expect? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[PaulDBrown · Accepted solution]

@Anonymous 

Try changing the reference in your measure from ALL(Details[ModelName])) to ALL(CarModel[ModelName]) -assuming that you are using the CarModel[ModelName] as your slicer.

var cptotal = CALCULATE( COUNT(Details[CarID]);
                       Details[Delivery Year]= selectedyear ;
                       Details[RetailCountryCD]= selectedcountry;
                            ALL(CarModel[ModelName]))

[Anonymous]

I have redeployed and refreshed the model and this has started working. Thanks @PaulDBrown 

[Anonymous]

Thanks. But seems this has no impact. Result is same.