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

Anonymous
Not applicable

## Summarizing values in measure with IF statement

Hello,

Please see below. I have a dataset that shows manager name, measure (T_70_75) that puts 1 if score between 70-75, else 0, and the year/month of the score (1st screenshot below). I want to sum the the 1's across all months (2nd screenshot), so if a manager had a score of 70-75 for 2 months, sum to 2 for each manager, and so on. How can I do this?

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

According to your description, I create a sample, T_70_75 and Score are measures like yours.

Here's my solution, create a measure.

``Total Month at 70-75 = COUNTROWS(FILTER('Data','Data'[T_70_75]=1))``

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

Hi @Anonymous ,

According to your description, I create a sample, T_70_75 and Score are measures like yours.

Here's my solution, create a measure.

``Total Month at 70-75 = COUNTROWS(FILTER('Data','Data'[T_70_75]=1))``

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

Hi @Anonymous

can you paste a screenshot of your source data table?

Anonymous
Not applicable

Sure,  see below. Score is the numerator divided by denominator. I then created a measure called 'T_70_75' (prior screenshot from the first post) that is an if statement, if between 70-75 put 1, else 0. I want to count the number of 1's for each manager having that score range for each month period.

Super User

Hi @Anonymous

SUMX (

SUMMARIZE ( TableName, TableName[Manager], TableName[Year Month Number] ),

)

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 - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors