Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measurement SUM

Hello all,    I think it is an easy one. But I really can't help myself.    At the moment I am creating a measurement which is meant to be the sum of two different fields this way:    BP in € ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Anonymous ,

    According to the picture you provided, there is a spelling error in your dax in the picture, HASONEVALUE, which you entered as HASONVALUE, missing an "e".

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

Check that you don't have Averages turned on

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your message. I do not even have the option to choose from those fields. Do you know the reason why? Is it because of measurement? BP in € = average(Worksheet[Price per Item])*average(Plan[Business Plan])