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

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -