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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Need Count problem with condition

I have to write one measure which counts the number of Rows, but it should have two type of Filter. 

 

Like the below image: We need count via Company wise. But should have 2 conditions 

 

1. For company C1 and E1 we need check Cases number =1 and Admission  = "N"

2. Rest of other company we need to check Case Number = 1

 

Can you please help me how I write measurer to calculate a count. 

 

Screenshot_4.png

 

 

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

try this

Measure = 
VAR C1_E1_filter = FILTER('Table','Table'[Company] in {"C1","E1"} && 'Table'[Admission] = "N" && 'Table'[# Cases] =1)
VAR C1_E1 = CALCULATE(COUNTROWS('Table'),C1_E1_filter)
VAR Else_filter = FILTER('Table','Table'[Company]<>"C1" && 'Table'[Company]<>"E1" && 'Table'[Admission] = "N")
VAR Else_value = CALCULATE(COUNTROWS('Table'),Else_filter)
RETURN
C1_E1+Else_value


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

try this

Measure = 
VAR C1_E1_filter = FILTER('Table','Table'[Company] in {"C1","E1"} && 'Table'[Admission] = "N" && 'Table'[# Cases] =1)
VAR C1_E1 = CALCULATE(COUNTROWS('Table'),C1_E1_filter)
VAR Else_filter = FILTER('Table','Table'[Company]<>"C1" && 'Table'[Company]<>"E1" && 'Table'[Admission] = "N")
VAR Else_value = CALCULATE(COUNTROWS('Table'),Else_filter)
RETURN
C1_E1+Else_value


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

Thanks, it works... 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors