Get the number of identical values in one column

[Dorothee123]

Hi there,

on of my table columns in Power BI containts several fields with an identical value. I want to divide by the number of fields with the identical value. Which expression do I use? Can anyone help me with that?

Thank you

Dorothee

[amitchandak]

@Dorothee123 , Not clear to me

count(Table[col])/distinctcount(Table[col])

[Dorothee123]

Well, I want to count the total number of values for each of these categories, i.e.

My output should be something like

17 values for AzureBillingUsageApril2020

22 values for AzureBillingMai2020 etc

[v-easonf-msft · Accepted solution]

Hi, @Dorothee123 

if you  just want to get the count by source.name ,Please try the function "Group by"

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Dorothee123 add a measure like this

Record Count = COUNTROWS ( Table )

In table visual, drag source name and above measure, and you will get the count by source.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[parry2k]

@Dorothee123 it will be easier to understand your question if you post some sample data and expected output.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490