Distinct Count Total

[rmeng]

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

[Angith_Nair]

Hi @rmeng ,

Try with this measure..

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

[rmeng]

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]

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

[rmeng]

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

[ERD]

Hello @rmeng ,

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

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