How to calculate distinctcount with date and text type

[Moni]

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 text type cannot be used as true/false or text type cannot be used in filter with distinct count.

can anyone help me please.

I want output to be gareth 2 weeks, Darran 1 week (since 12/11/21 repeating so distinct count)

[Anonymous · Accepted solution]

Nbweek = calculate(DISTINCTCOUNT(Weekending[WeekEnding]))

[daXtreme]

Measures don't have to be wrapped in CALCULATE as the engine does it automatically.

So, the final formula would be:

Nbweek = DISTINCTCOUNT( Weekending[WeekEnding] )

[Moni]

Hi @Anonymous 

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)