topic Can only create one measure in DAX Commands and Tips

Can only create one measure

Yrstruly2021 — Wed, 08 Feb 2023 20:43:34 GMT

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

Re: Can only create one measure

v-jianboli-msft — Thu, 09 Feb 2023 01:57:49 GMT

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.

Re: Can only create one measure

Yrstruly2021 — Thu, 09 Feb 2023 05:11:58 GMT

See if you can create more other measures?

Re: Can only create one measure

v-jianboli-msft — Thu, 09 Feb 2023 05:40:05 GMT

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.

Re: Can only create one measure

Yrstruly2021 — Thu, 09 Feb 2023 09:08:02 GMT

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=104129043494164133703&rtpof=true&sd=true

Re: Can only create one measure

v-jianboli-msft — Thu, 09 Feb 2023 09:44:11 GMT

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.