Forum Discussion

rmeng's avatar
rmeng
Helper 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 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

 

 

 

 

 

5 Replies

  • Angith_Nair's avatar
    Angith_Nair
    Continued Contributor
    5 years ago

    Hi rmeng ,

    Try with this measure..

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

     

     

    • rmeng's avatar
      rmeng
      Helper 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
        Continued Contributor
        5 years ago

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

         

  • ERD's avatar
    ERD
    Community Champion
    5 years ago

    Hello rmeng ,

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

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