MS Fabric DAX Function: DISTINCTCOUNT BUG?

[rgcabusas]

Hi Community,

I have this simple DAX Function which is DISTINCTCOUNT. I expected to get 1 value in each PR Number since I am using a DISTINCTCOUNT but if you look at the result, It returned a wrong value.

I tried to validate it by drag and drop PR Number and select count(distinct) in the fields but same result. It doesn't return a distinct count of the data.

I tried this using PowerBI import mode and I got the right value.

Regards,

[Anonymous]

Hi @rgcabusas 

DISTINCTCOUNT counts the number of distinct values in a column . 

To determine if it is problematic, you need to provide a simple sample to restore your scenario, and in that sample , you can prove that it is wrong. We need to verify it with the sample you provided and if it is confirmed that it is problematic, then we will send this issue back to PG. Thank you for your cooperation !

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao