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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SL_1983
Helper II
Helper II

If function in a measure with multiple conditions

Good morning,

 

I have the following calculated columns:

Number of Packages 4 pax = if('Ingredients'[Qty] <= 'Ingredients'[Package Content];1;2)

Number of Packages 3 pax = if(('Ingredients'[Qty]/4)*3 <= 'Ingredients'[Package Content];1;2)

Number of Packages 2 pax = if(('Ingredients'[Qty]/4)*2 <= 'Ingredients'[Package Content];1;2)

Number of Packages 1 pax = if(('Ingredients'[Qty]/4) <= 'Ingredients'[Package Content];1;2)

 

Is there any way to make one measure for this instead of 4 calculated columns?

 

Thanks for your help.

 

Kind regards

 

 

1 ACCEPTED SOLUTION

Hi @SL_1983 

 

Can you try changing that measure to below (you will not need the 4 columns you created):

 

Kostprijs Per Aangekochte Verpakking = SUMX ('Ingrediënten', ('Ingrediënten'[Verpakking Gewicht Laagste Prijs] * IF(( 'Ingrediënten'[Recept Hoeveelheid 4 Personen] / 4 ) * SELECTEDVALUE ( 'Slicer Table'[Recept  aantal Personen] ) <= 'Ingrediënten'[Verpakking Gewicht Laagste Prijs], 1, 2)) * RELATED ( 'Product'[Goedkoopste Prijs] ))

 

Hope that helps! 

View solution in original post

3 REPLIES 3
bheepatel
Resolver IV
Resolver IV

Hi @SL_1983 

 

Can you please provide a sample of your dataset and the desired output?

Hello,

 

This is the link to the pbix file (however it is in Dutch): https://1drv.ms/u/s!AuaqHTxLCZ_h0wB8UX412RXRsm88?e=iMha2O

 

The 4 colums have been created in the table Ingrediënten. 

Then I created a measure: "Kostprijs Per Aangekochte Verpakking" to be able to calculate the cost of the recipe based on the number of packages that have to be bought to make the dish.

 

Kind regards,

 

Hi @SL_1983 

 

Can you try changing that measure to below (you will not need the 4 columns you created):

 

Kostprijs Per Aangekochte Verpakking = SUMX ('Ingrediënten', ('Ingrediënten'[Verpakking Gewicht Laagste Prijs] * IF(( 'Ingrediënten'[Recept Hoeveelheid 4 Personen] / 4 ) * SELECTEDVALUE ( 'Slicer Table'[Recept  aantal Personen] ) <= 'Ingrediënten'[Verpakking Gewicht Laagste Prijs], 1, 2)) * RELATED ( 'Product'[Goedkoopste Prijs] ))

 

Hope that helps! 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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