Forum Discussion
Additional Measure to be defined
I have this below table for which, I need to determine the average value per Product category based on the country. I am able to get the values using the below measure . But I am getting stuck when I...
Hi Diptarup ,
1. I used the following formula to calculate the average of each Category and Parameter
=CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[Product Category],'Table'[Paramter]))As the output shown, P1 in Product Category B =0.38 not 0.59 ; P2 in Product Category B =0.33 not 0.41
2. Since you want to calculate P1*0.59+P2*0.41 , it seems that Parameter column should be Int type not Text type,right?
Please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.