Forum Discussion

rmeng's avatar
rmeng
Icon for Helper II rankHelper II
5 years ago

Distinct Count Total

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 co...
Angith_Nair's avatar
Angith_Nair
Icon for Continued Contributor rankContinued Contributor
5 years ago

Hi rmeng ,

Try with this measure..

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