Exclude some values from distinctcount

[Astolfo]

Hi all, 

i have a list of brands that i filter  by year and week and i show the distinct number of them with this function: 

Brands = DISTINCTCOUNT( Cartel1[Fornitore])

Want to know if i can exclude some of them from the count, for example ADIDAS and Giorgio Armani.

Thank you!

[amitchandak · Accepted solution]

@Astolfo ,

Brands =calculate( DISTINCTCOUNT( Cartel1[Fornitore]),filter(Cartel1,not [Fornitore] in {"ADIDAS","Giorgio","Armani"})) 

or refer to exclude using slicer- Power BI Exclude selected Slicer value, Independent Table: https://youtu.be/lOEW-YUrAbE

[Astolfo]

Both measures work well, many thanks!!!

[HassanAshas · Accepted solution]

Does this work for you? 

Brands = DISTINCTCOUNT ( Cartel1[Fornitore] )

Total Brands =
CALCULATE (
    [Brands],
    FILTER ( Cartel1, not [Fornitore] in {"ADIDAS","Giorgio Armani"} )
)

[amitchandak · Accepted solution]

@Astolfo ,

Brands =calculate( DISTINCTCOUNT( Cartel1[Fornitore]),filter(Cartel1,not [Fornitore] in {"ADIDAS","Giorgio","Armani"})) 

or refer to exclude using slicer- Power BI Exclude selected Slicer value, Independent Table: https://youtu.be/lOEW-YUrAbE