DISTINCTCOUNTNOBLANK is not filtering out BLANK values

[Anonymous]

Hello,

as stated in the subject, the DISTINCTCOUNTNOBLANK function is not filtering out BLANK values in a column. This means that its result is always equal to the one returned by the DISTINCTCOUNT function.

I know I can use CALCULATE to filter out BLANK values, but why introduce a new function like DISTINCTCOUNTNOBLANK to achieve this goal, if it isn't working as intended?

Is there any chance this will be fixed in the near future?

Thank you very much.

Kind regards,
Amedeo Maggini

[v-qiuyu-msft]

Hi @Anonymous, 

Based on my test in Power BI desktop version 2.80.5803.1061 64-bit (April 2020), the 

DISTINCTCOUNTNOBLANK() function does work as expected. You can test with our sample report: 

Best Regards,
Qiuyun Yu

[Anonymous]

Hello @v-qiuyu-msft ,

thank you very much for your help.

Upon further analysis I discovered that Power Query was importing NULL values in string columns as empty strings, as this is its default behavior with text columns in csv files.

Thank you very much for your help!


Kind regards,

Amedeo