cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

I created a new measure but the values are not changing in each column

Dears,

I have created a new Measure. see below

AVG Price = DIVIDE(
sum('PO_DETAILS_RPT'[REC_TOT_PRICE]),
)

I created a matrix  like this to report the average price per item per month

 item ID Month 1 Month 2 Month 3 Month .... 1 1.2 1.2 1.2 1.2 2 7.5 7.5 7.5 7.5 3 4 4 4 4

the problem is that the prices are not constant and keep changing from day to day but in the report is showing as constant month on month. Maybe I need to modify my measure a little bit. the expected output is something like this

 item ID Month 1 Month 2 Month 3 Month .... 1 1.2 1.8 1.25 1.7 2 7.5 7.58 4.6 8.5 3 4.8 4.78 4.99 4.88
5 REPLIES 5
New Member

I guess the source of error coming from the aggregation of the  [REC_TOT_PRICE] and [QTY_RECEIVED] . maybe the report is getting both [REC_TOT_PRICE] and [QTY_RECEIVED] for all time

Community Support

Hi, @OMS_POWERBI

Can you share relevant formulas of the [REC_TOT_PRICE] and [QTY_RECEIVED]?

If possible, please share a sample pbix for further research.

Best Regards,
Community Support Team _ Eason

New Member

thanks for your support.

The below formula returned an unrealistic number. maybe because of the red part

AVG Price = DIVIDE(
)

the second formula did not work. it give syntax error

Super User

could you pls provide the sample data?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User

@OMS_POWERBI , I think it should be like this

AVG Price = DIVIDE(
)

TO make it constant , try allexcept

AVG Price =calculate(  DIVIDE(
), allexcept('PO_DETAILS_RPT', 'PO_DETAILS_RPT'[Month Year]) )

//you can use your formula too

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.