Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
kressb
Helper V
Helper V

Calculate Unique Visits

Data table linked to a Key and Date Dimension:

VolumeDemo.png

I want to calculate a 1 the first time a Patient ID appears per service date.

If a Patient ID appears multiple times on a particular service date, I only want to calculate a 1 the first time it appears.
Is there an easy way to do this as a calculated column?

 

1 ACCEPTED SOLUTION
kressb
Helper V
Helper V

I ended up concatenating Pat_ID and Orig_Service_Date and then doing a Distinct Count of that

View solution in original post

3 REPLIES 3
kressb
Helper V
Helper V

I ended up concatenating Pat_ID and Orig_Service_Date and then doing a Distinct Count of that

mahoneypat
Microsoft Employee
Microsoft Employee

You should probably do this as a measure and not a column.  Here is one way to do it, if I understand your scenario correctly.

 

Unique Visits = COUNTROWS(SUMMARIZE(Data, Data[Pat_ID], Data[Orig_Serv_Date]))

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Can't be a measure.

Must be a calculated column as there are about 10 other columns not shown that the # has to interact with.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.