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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, 

 

thank you for your post! That is what I am thinking of - but why do Power BI Desktop do not accept the last part of the formula. It seems that it is not possible to include the Business Plan part in this measurement? 

 

PC2790's avatar
PC2790
Community Champion
4 years ago

If there is a relation between Plan and Worksheet, try using RELATED Dax.

something like:

BP in € = SUMX(Worksheet,Worksheet[Price per Item]*RELATED(Plan[Business Plan]))