Can only create one measure

[Yrstruly2021]

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 the issue?

https://drive.google.com/file/d/1TBRgP2tHPRQBcDUMqV0rWeIzV3lH0ebj/view?usp=share_link 

[v-jianboli-msft]

Hi @Yrstruly2021 ,

It works fine.

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]

See if you can create more other measures?

[v-jianboli-msft]

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.

[Yrstruly2021]

I can not create more avg measures, e.g avg total cost etc.

https://docs.google.com/document/d/1vjSp7x1DQPe9cmjGjRXXfkkV4Ii4Xxkt/edit?usp=share_link&ouid=104129... 

[v-jianboli-msft · Accepted solution]

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.