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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
billuran2009
Helper I
Helper I

Calculate function multiple values

I have a calculate function:
CALCULATE(sum(ARCharges[QUANTITY]),ARCharges[PROCEDURE CODE]="R&B")
 
I want to include 2 other conditons "LVR&B "and "PBR&B" how can I sun those charges for just those 3 procedure codes.
 
1 ACCEPTED SOLUTION
FrankAT
Community Champion
Community Champion

Hi @billuran2009 ,

I think you can do it like this:

 

CALCULATE(SUM(ARCharges[QUANTITY]),ARCharges[PROCEDURE CODE] IN {"R&B", "LVR&B ", "PBR&B"})

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

View solution in original post

1 REPLY 1
FrankAT
Community Champion
Community Champion

Hi @billuran2009 ,

I think you can do it like this:

 

CALCULATE(SUM(ARCharges[QUANTITY]),ARCharges[PROCEDURE CODE] IN {"R&B", "LVR&B ", "PBR&B"})

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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