Forum Discussion

_Alex_'s avatar
_Alex_
New Member
7 years ago
Solved

DAX Help: Unique count by row II

Suppose I have a dataset as follows:   Car_ID    Owner_Name  Car_Owner_State  Unique_State_Count 1             Adam               FL                         2 1             Bob                  F...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi _Alex_

    Created calculated column

    Unique_State_Count1 = CALCULATE(DISTINCTCOUNT(Table1[ Car_Owner_State]),ALLEXCEPT(Table1,Table1[Car_ID]))

     

    Or measure

    Measure = CALCULATE(DISTINCTCOUNT(Table1[ Car_Owner_State]),ALLEXCEPT(Table1,Table1[Car_ID]))

     

    Best Regards

    maggie

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago
Hi

Try with

Calculate(distinctcount (table1[carownerstate]), allexcept (table1,table1 [car id]))