cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Count number of doctors who had cases in a month or year

I am trying to get a measure to get a count of the number of doctors who had cases in a given month or year.  Here I calculated the number of doctors in excel.

I can send you the data in excel, but I have not had good luck posting the files using dropbox.  Let me know if you need that and I will try

I have a date table in my model constructed using Calendarauto.

1 ACCEPTED SOLUTION
Super User

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

``````Expected result measure: =
VAR _countsum =
SUM ( Data[Count] )
VAR _doctorcount =
COUNTROWS ( SUMMARIZE ( Data, Doctor[Doctor] ) )
RETURN
IF ( HASONEVALUE ( Doctor[Doctor] ), _countsum, _doctorcount )
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

2 REPLIES 2

@Jihwan_Kim  That works just fine - thank you very much

Super User

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

``````Expected result measure: =
VAR _countsum =
SUM ( Data[Count] )
VAR _doctorcount =
COUNTROWS ( SUMMARIZE ( Data, Doctor[Doctor] ) )
RETURN
IF ( HASONEVALUE ( Doctor[Doctor] ), _countsum, _doctorcount )
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors