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
htalat6
Frequent Visitor

Calculation in measure

Hey i am trying to recreate this calculated field on Power BI

I want to calculate number of times this situation occurs , i used the following type of formula on tableau. Because of limitations i am moving to Power BI so need help.

 

sum( if columna = 'abc' and (columnb = 'fg' or columnc ='th') then 1 end)

 

Thanks in advance

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@htalat6 - you can do as

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Hey Chris ,

Thanks for the reply i think it will do it . what function here should i use to sum the trues? sum()?

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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
Top Kudoed Authors