cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Need help please. I need to to COUNT column ID if Sum of column A or column B hits a thresh-hold.

Hi.  I need some help please.

I need to count column ID if the SUM of column A is greater than 25 or column B is greater than 250. There are duplicate IDs in the dataset, so if the SUM of column A or column B for these duplicate IDs are above the thresh-hold then it should be counted, not individually.

I have attached a link to the Power BI file.  For the dataseset in the file, the number I am looking for is: 24

Thanks!

Power BI file:

https://drive.google.com/file/d/11GRAerF7N79UY-OrOX_7DqzrpktoLLc6/view?usp=sharing

1 ACCEPTED SOLUTION
Super User

Hi,

Please check the below measure and the attached pbix file.

``````Count =
VAR conditionA =
FILTER ( VALUES ( Worksheet[ID] ), CALCULATE ( SUM ( Worksheet[A] ) ) > 25 )
VAR conditionB =
FILTER ( VALUES ( Worksheet[ID] ), CALCULATE ( SUM ( Worksheet[B] ) ) > 250 )
VAR conditionAorB =
DISTINCT ( UNION ( conditionA, conditionB ) )
RETURN
COUNTROWS ( conditionAorB )``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

2 REPLIES 2
Helper I

Yes.  This worked!

Super User

Hi,

Please check the below measure and the attached pbix file.

``````Count =
VAR conditionA =
FILTER ( VALUES ( Worksheet[ID] ), CALCULATE ( SUM ( Worksheet[A] ) ) > 25 )
VAR conditionB =
FILTER ( VALUES ( Worksheet[ID] ), CALCULATE ( SUM ( Worksheet[B] ) ) > 250 )
VAR conditionAorB =
DISTINCT ( UNION ( conditionA, conditionB ) )
RETURN
COUNTROWS ( conditionAorB )``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

## Helpful resources

Announcements

#### Check it Out!

Click here to learn more about the August 2022 updates!

#### The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

#### Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors