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
Icon for Community Champion rankCommunity 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

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hey Moni I saw now you acceted my solution. Making sure it was solved cause this is the last reply you wrote to me.