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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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 )

 

    Microsoft MVP
 

 

   


      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.


   


     
        LinkedInVisit my LinkedIn page
     

   


   


     
        Outlook BookingSchedule a short Teams meeting to discuss your question

     

   


 


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 )

 

    Microsoft MVP
 

 

   


      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.


   


     
        LinkedInVisit my LinkedIn page
     

   


   


     
        Outlook BookingSchedule a short Teams meeting to discuss your question

     

   


 


Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.