How to get the total count of distinct values from a result table

[trisa1999]

Hello! I am trying to get the total count of distinct name values from a result table. For example, I have slicers that return results of referring providers for a given time range. I would like to get the number of duplicate provider names from the results. So if a doctor referred 4 times in a specific time frame and another doctor referred 6 times, I would like to show another result table with the amount of times each provider referred. Hope that makes sense.

Thanks in advance!

[v-piga-msft]

Hi @trisa1999,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[BKirsch12]

You can use a card to display the distinct count of providers:

Distinct = DISTINCTCOUNT(Provider column])

If you need to know how many times a provider was listed, you'll want to do a group by.

You need to use a calculated table (Select new table and use this DAX):

Count = SUMMARIZE( Table with Provider column,Provider column,"Count",Count(Provider column)) 

Let me know how that works, thanks.

[trisa1999]

Thanks for your response. When using the Summarize DAX expression I receive the following error:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Here is the expression - DistinctProviderCount = SUMMARIZE(DoctorFacility,DoctorFacility[ListName],"Count",COUNT(DoctorFacility[ListName]))