Forum Discussion

karkar's avatar
karkar
Icon for Helper III rankHelper III
9 years ago
Solved

DISTINCT VALUE

Hello,   How can I get unique value per ID from the below example? Currently it is giving the count of meas_value. i tried to change it to Calculate(DISTINCTcount(Query1[value]), in the below form...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    karkar,


    Please check if the following DAX returns your expected result.

    Total Count = Calculate(max(Query1[value]),Filter(ALL(Query1[Admission_Hours]),Query1[Admission_Hours] >72))

    Regards,

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago
Hi karkar,

You should do the distinct count on the ID column not on the value because it's what you want to count not the value column.

Regards,
MFelix
karkar's avatar
karkar
Icon for Helper III rankHelper III
9 years ago

Like THIS?

 

Total Count = Calculate(DISTINCTcount(Query1[ID]),

                       Filter(ALL(Query1[Admission_Hours]),Query1[Admission_Hours] >72))

 

But I ALSO WANT TO SHOW THE UNIQUE "VALUES" AN id CONTAINS

  • karkar's avatar
    karkar
    Icon for Helper III rankHelper III
    9 years ago

    Currently the output is (since its counting 7 times)

    ID    totalcount

    101   7

     

    WANT:

    ID   totalcount

    101   0      (DISTINCT VALUE FOR EACH 'ID')

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      karkar,


      Please check if the following DAX returns your expected result.

      Total Count = Calculate(max(Query1[value]),Filter(ALL(Query1[Admission_Hours]),Query1[Admission_Hours] >72))

      Regards,