Forum Discussion

mrvamsidhar's avatar
mrvamsidhar
Icon for Helper I rankHelper I
9 years ago
Solved

Distinct Count of Measure Column

Hello, I want to calculate Disticnct count of Column1 based on Column2. I added a Measure Column  DISTINCTENV = DISTINCTCOUNT(Sheet1[Environment]) which gives below output.     Original Table: ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    mrvamsidhar

     

    Hi, try with this:

     

    DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

mrvamsidhar

 

Hi, try with this:

 

DCMeasure = SUMX(VALUES(Table1[Exterprise]);DISTINCTCOUNT(Table1[Environment]))

  • mrvamsidhar's avatar
    mrvamsidhar
    Icon for Helper I rankHelper I
    9 years ago

    Thanks this helped.