calculate distinctcount of a column when another column is blank and when is not blank

[PieroPinzone95]

Hi I would like to calculate the distinctount of the column IdPolizza, when a second column (CodicePolizzaCollettiva) in the same table is blank ( and also when is not blank). The data type of CodicePolizzaCollettiva is Text, while IdPolizza's one is Integer.

I tried these for when is not blank

-CALCULATE(distinctCOUNT(VW_Polizze[IdPolizza]), ALLNOBLANKROW(VW_Polizze[CodicePolizzaCollettiva]))

-CALCULATE (DISTINCTCOUNT (VW_Polizze[IdPolizza] ), KEEPFILTERS ( NOT ISBLANK ( VW_Polizze[CodicePolizzaCollettiva]) )

and these when is blank

CALCULATE(DISTINCTCOUNT(VW_Polizze[IdPolizza]), VW_Polizze[CodicePolizzaCollettiva] = "")

CALCULATE(COUNT(VW_Polizze[IdPolizza]),VW_Polizze[CodicePolizzaCollettiva]=BLANK())

but no one has worked...any tip?

[tamerj1 · Accepted solution]

Hi @PieroPinzone95 
Seems to be a filter context issue. How are you displaying the results(s)?