topic Re: Count number of doctors who had cases in a month or year in DAX Commands and Tips

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

BaldAccountant — Fri, 31 Mar 2023 18:11:47 GMT

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.

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

Jihwan_Kim — Fri, 31 Mar 2023 20:26:22 GMT

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 )

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

BaldAccountant — Mon, 03 Apr 2023 12:24:27 GMT

Jihwan_Kim That works just fine - thank you very much