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.

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

See if you can create more other measures?