Forum Discussion
Helper VCan 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 the issue?
https://drive.google.com/file/d/1TBRgP2tHPRQBcDUMqV0rWeIzV3lH0ebj/view?usp=share_link
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.
5 Replies
v-jianboli-msftCommunity Support
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.
Yrstruly2021I can not create more avg measures, e.g avg total cost etc.
- v-jianboli-msft
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
See if you can create more other measures?
- 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.