How to count number of rows with specific column value?

[OdiAssli]

Hi, 

I have the below table and I would like to add new column (custom column?) that will count number of "Names" that have the same "Age" value. then I will display the data into table in report

Name	Age
Odi	27
Sofian	27
Ludmila	29
Yousef	30
Eilon	30

Thanks

[Syndicate_Admin]

Hello Good morning,

I'm trying to make a report and I want to know how I can take the following example in pbi

example:

I have a date of 1000 tickets per month and I want to take out how many have been met per month and it looks like the picture in pbi

I appreciate your help.

[Syndicate_Admin]

Good morning, I don't allow myself to make a column with those formulas, unless I made a measure, but if I need the column as I could?

[az38]

Hi @OdiAssli 

try

Column = calculate(DISTINCTCOUNT('Table'[Name]), ALLEXCEPT('Table', 'Table'[Age]))

[OdiAssli]

Hi @az38 ,

Is it Power BI formula? I got this error:

Expression.Error: The name 'calculate' wasn't recognized. Make sure it's spelled correctly.

[az38 · Accepted solution]

Hi @OdiAssli 

CALCULATE (case insensitive) is a BASE power BI statement. I don't know any statement that would be more power BI than CALCULATE 🙂

[OdiAssli]

Works good, Thank you @az38  😀