topic Re: Count distinct values of a column in DAX Commands and Tips

Count distinct values of a column

Anonymous — Tue, 14 Dec 2021 13:54:31 GMT

In power: when i use distinctcount or distinctcountnoblank functions then im getting the distinct count is 7 but in spotfire its 5 count.... could you please help on this please asap

spotfire CALS:

// spt: UniqueCount([Dictionary_SBSCTR]) over ([REGN_NAME],[SUB_SECTR_NAME],[IN_P6M])

Power BI dax: tried with many types of dax ways but coudlnt get correct results. could you please do the needful on this asap, amitchandak , VahidDM or anybody else can help on this.

_Dict_Count =

CALCULATE(DISTINCTCOUNT('Usage Tracking'[Dictionary_SBSCTR]),ALLEXCEPT('Usage Tracking','Usage Tracking'[REGN_NAME], 'Usage Tracking'[SUB_SECTR_NAME]))

SPOTFORE DATA:

POWER BI DATA:

Re: Count distinct values of a column

smpa01 — Tue, 14 Dec 2021 14:21:36 GMT

Anonymous please provide sample data in table format here

Re: Count distinct values of a column

Watsky — Tue, 14 Dec 2021 14:47:32 GMT

Hey Anonymous ,

Do you have anything joined to the dataset? I'm showing 5 for the count on my end. Unless what you're saying is the total should be 7?

Re: Count distinct values of a column

Anonymous — Wed, 15 Dec 2021 05:35:11 GMT

Watsky I agreed with your results but in my power bi file its not showing it. In my power bi file its not coming correct count as you got it.

Re: Count distinct values of a column

Anonymous — Wed, 15 Dec 2021 05:37:22 GMT

I'm unable to attached the excel or csv file or pbix file here. im gettting below errors. could you please help me how to attach the files so that i would share with you

Re: Count distinct values of a column

Anonymous — Wed, 15 Dec 2021 06:25:04 GMT

there is no joinig, only one table is present in power bi file

Re: Count distinct values of a column

Watsky — Wed, 15 Dec 2021 16:28:40 GMT

Anonymous ,

Send the file to onedrive or google drive then post the link to it here.