Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
The_Clam
Helper I
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
Jihwan_Kim
Super User
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


View solution in original post

2 REPLIES 2
The_Clam
Helper I
Helper I

Yes.  This worked!

Jihwan_Kim
Super User
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.