Forum Discussion
SL_1983
Helper II
Helper IIIf 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]/...
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!
SL_1983Helper II
Helper IIHello,
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,
bheepatel
Resolver IV
Resolver IVHi 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!