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 ) )

 

 

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

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

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

     

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

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