topic Re: Distinct Count Total in DAX Commands and Tips

Distinct Count Total

rmeng — Wed, 24 Mar 2021 17:56:47 GMT

Hello,

I have a table with a measure # TierJav = DISTINCTCOUNT(JAVELLIN[ACCOUNT_TIER]).

The purpose is to have a measure to give me this result instead:

That has the distinct count of ACCOUNT_TIER added in row, removing filter context of Month_YEAR (ALL Function I suppose).

Month_YEAR is a column from DIM CALENDAR not from the Fact Table JAVELLIN.

Can you help me with this?

Thanks

ERD — Thu, 25 Mar 2021 09:16:17 GMT

Hello rmeng ,

You can use COUNTAX (<Table>, <Expression>) function with ALL:

#measure = COUNTAX(ALL(Table[Column]),Table[Column])

Angith_Nair — Thu, 25 Mar 2021 11:48:24 GMT

Try with this measure..

Measure = CALCULATE ( DISTINCTCOUNT ( JAVELLIN[ACCOUNT_TIER] ), ALL ( DIMCALENDAR ) )

rmeng — Fri, 26 Mar 2021 14:22:56 GMT

Sorry for the late response, but the result still bring 1 instead of 2 in #TierJav Measure.

I also though that could be the answer.

Angith_Nair — Fri, 26 Mar 2021 14:53:13 GMT

Could you please share the pbix file so that I can look into the issue...?

rmeng — Fri, 26 Mar 2021 16:11:20 GMT

Sure, let me first create a new PBIX because this is sensitive data. Thanks