Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to calculate the total recipe cost price for each recipe. I used the below DAX formula as shown in the image and also listed below but I am not getting the correct result. I am trying to acheive this in a Power Bi Matrix visual. Please help.
Recipe Total Cost Price = Calculate(SUM('All Recipes'[Ingredient_Cost_Price]), ALLEXCEPT('All Recipes','All Recipes'[Recipe Name]))
Solved! Go to Solution.
HI @sustar2020,
You can try to use the following measure formula if that is suitable for your requirement:
Recipe Total Cost Price =
CALCULATE (
SUM ( 'All Recipes'[Ingredient_Cost_Price] ),
ALLSELECTED ( 'All Recipes' ),
VALUES ( 'All Recipes'[Recipe Name] )
)
Regards,
Xiaoxin Sheng
Hi, sorry, it didn't work. It's giving an empty column.
HI @sustar2020,
You can try to use the following measure formula if that is suitable for your requirement:
Recipe Total Cost Price =
CALCULATE (
SUM ( 'All Recipes'[Ingredient_Cost_Price] ),
ALLSELECTED ( 'All Recipes' ),
VALUES ( 'All Recipes'[Recipe Name] )
)
Regards,
Xiaoxin Sheng
@sustar2020 , if Ingredient_Cost_Price is a column this seems fine to me
But you can try
Recipe Total Cost Price = Calculate(SUM('All Recipes'[Ingredient_Cost_Price]), filter(allselected('All Recipes') ,'All Recipes'[Recipe Name] = max('All Recipes'[Recipe Name]) ))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |