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 VahidDM 

     

    the post really sums up my problem! Thanks for that. 

     

    EDIT: I do not know how to use this 

     

    AVERAGE Revenue = IF ( HASONEVALUE ( 'Table'[Store] ), AVERAGE ( 'Table'[Revenue] ), SUMX ( SUMMARIZE ( 'Table', 'Table'[Store], "AVERAGEC", AVERAGE ( 'Table'[Revenue] ) ), [AVERAGEC] ) )

     

    in the case of my formula BP in € = average(Worksheet[Price per Item])*average(Plan[Business Plan]) 

     

    ________________________________________________________________________________________________________________

    Now I have tried to enter the formular for the measurement, but the formulare wont accept the first part. Could you take a look at it? It think the part after hasonvalue seems wrong. 

     

     

    "Price per item" has a sum symbol, do not know if this is the reason why i cant enter it in the formula? 😞