Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Icon for Helper V rankHelper V
3 years ago
Solved

Can only create one measure

Please advise, i can only create one measure (avg transaction) with this workbook. When I tried to create more measures it only gives me the measure I already created as an option. Are my data type t...
Data Type
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi  Yrstruly2021 , 

     

    It seems that you already have a MEASURE [AVG]:

    If you want to calculate average, please try to use AVERAGE() like this:

     

    Measure = CALCULATE(AVERAGE(content_type[cost]))

     

    Output:

    AVERAGE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Yrstruly2021 ,

 

It works fine in my side. Sorry I can't reproduce the error you describe, did I misunderstand?

What kind of MEASURE are you trying to create?

Can you provide a detailed screenshot of the error message?

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.