Power Pivot - Occurrence Query

[gmazza76]

Good Afternoon

I am trying to complete a query "Count" of how many times a holiday has been booked on a day and I am having a couple of issues.
As per the screenshot below I am trying to confirm how many times I have entered a holiday, but the holidays are shown as separate days on the file I am currently using in Power Pivot.
I need to be able to cross reference the "Entered Date" with the "Name" to confirm how many have been completed on the day.

Currently anything I think of would register the "Me" as having entered 5 separate entries on the 01/11/20 where I would only enter 1.
I am unsure of the best way of counting the below.

All help appreciated.
thanks
Gavin

 

[sandy666]

maybe use DISTINCTCOUNT – DAX Guide

 

[gmazza76]

Can I put the distinct count in Power Pivot

 

[gmazza76]

maybe use DISTINCTCOUNT – DAX Guide

Cheers I will have a look at the link

 

[sandy666]

Can I put the distinct count in Power Pivot

see post#11

 

[sandy666]

Cheers I will have a look at the link

sure, good luck

 

[gmazza76]

I think its down to countrows and calculate, but unsure of how to implement it.
Google time I think

 

[sandy666]

you mean you don't know how to enter measure?
You can do that via formula bar if you want

or I misunderstood

 

[gmazza76]

Sorry @sandy666, you were spot on with the "Distinct Count" in the Pivot Table.
I think I was over thinking things

 

[sandy666]

No problem
Have a nice day