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

PC2790's avatar
PC2790
Community Champion
4 years ago

As your formula is to calculate the average that' why the total is taking average of the column values.

The figures in the columns are fine because the calculation is happening on row by row basis.

Instead try this:

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

  • 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]))