Forum Discussion

Moni's avatar
Moni
New Member
4 years ago
Solved

To calculate distinctcount date with text type

I gotta column with weekending dates and another coulumn with full name, so im trying use DAX to calculate distinct value of each full name with no of weeks,    I'm getting error with full name as ...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Moni just to be sure, you put 'Table[Full Name] on rows of the matrix and created this measure:
    Distinct Weeks Measure = DISTINCTCOUNT('Table'[Week Ending]) 
    And put that measure on the values and it didn't work?

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Moni just to be sure, you put 'Table[Full Name] on rows of the matrix and created this measure:
Distinct Weeks Measure = DISTINCTCOUNT('Table'[Week Ending]) 
And put that measure on the values and it didn't work?

  • Moni's avatar
    Moni
    New Member
    4 years ago

    Hi SpartaBI 

    I tried those measures, it calculates distinctcount of weekending but not name, example it shows

     

    Darren 7 weeks

    Gareth 2 weeks

     

    but i expect answer,

     

    Daren 2 weeks (since 12/11/2021, 19/11/2021 only two days are ter)

    • SpartaBI's avatar
      SpartaBI
      Community Champion
      4 years ago

      Moni maybe these values are not really unique in the data. How did you created this column? Do you have maybe a sample data you can share?

      • Moni's avatar
        Moni
        New Member
        4 years ago

        Hi SpartaBI 

         

        Example

        Moni 12/1/2020

        yuvi   1/3/2021

        Moni 12/1/2020

        yuvi    1/3/2021

         

        Distinctcount(table(weekending)) 

        showing Moni 2 weeks

        Yuvi 2 weeks

         

        but what I expect is Moni 1 week

        Yuvi 1 week

    • rohit_singh's avatar
      rohit_singh
      Solution Sage
      4 years ago

      Hi Moni ,

      Adding name and distinct count of week ending gives me 2 weeks for both persons.


      Not sure what exactly your expected output is?


      Kind regards,

      Rohit


      Please mark this answer as the solution if it resolves your issue.
      Appreciate your kudos! ğŸ˜Š

      • Moni's avatar
        Moni
        New Member
        4 years ago

        Hi rohit_singh 

         

        I tried, changing count and everything

        I tried those measures, it calculates distinctcount of weekending but not name, example it shows

         

        Darren 7 weeks

        Gareth 2 weeks

         

        but i expect answer,

         

        Daren 2 weeks (since 12/11/2021, 19/11/2021 only two days are ter)