CODEWITHSUNDEEP
ssasdax
hevy
hevy

Reputation: 91

DAX distinctcount filtered column

I need to display distinctcount of column values filtered by other column values. I'm already display this values, but I don't know how to count it Here is my query:

evaluate summarize( FILTER( Products ,not isblank(Produkty[Brand]) && Produkty[Company] = "blabla" ) ,Produkty[Brand] )

Upvotes: 2

Views: 5681

Answers (1)

mmarie
mmarie

Reputation: 5638

I'm not sure if I got your field names correct, but this should do what you need. 

Count of BlaBla Brands:=
calculate(
       countrows(distinct(Products[Brand])), 
       Filter('Products', Products[Company] = "blabla" && not(ISBLANK(Products[Brand])))
)

Upvotes: 9

Related Questions