Tabular Model: DISTINCTCOUNT on field with blanks in DAX -
i understanding distinctcount function in dax supposed ignore blanks. i'd expect if had 2 unique values , blank in column distinctcount on column return 2.
i find continues return 3 i.e. blank treated value. how can change this?
i cannot find anywhere in tabular model can change equivalent of nullprocessing. have tried creating column blank() , returns count of 1 i'd expect 0.
all appreciated.
i got answer. using following dax numeric fields
calculate(distinctcount('sales'[someid]), 'sales'[someid] <> 0)
or
calculate(distinctcount('sales'[someid]), 'sales'[someid] <> "")
for character fields.
Comments
Post a Comment