Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I have created a report in power bi where by calculating the difference between the ASP by customer/product combination and the previous year agreed price, if the first one is bigger than the second one, the result is moltiplied by the quantity sold. The result is what I want to see, the impact of bigger prices versus smaller ones that im going to call the formula.
The problem comes when I have to split this by month and retrieve the total: in fact, the total ytd is not showing the overall amount of the formula for every month but a "wrong" one.
I think the wrong result is due to the fact that the formula, without any slicing, is taking the average sales price YTD instead aggregating by month (The month slicing is made it by a number value and not by date format)
This is the formula:
Solved! Go to Solution.
Hi @emarome94 ,
We can create a measure. Place [Measure] on the [Values] field of the matrix.
Measure =
SUMX(
SUMMARIZE(
'Table',
'Table'[RowName],
'Table'[ColumnName],
"total",[Baseline SKU ASP Increase Effect (period)]
),
[total]
)
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @emarome94 ,
We can create a measure. Place [Measure] on the [Values] field of the matrix.
Measure =
SUMX(
SUMMARIZE(
'Table',
'Table'[RowName],
'Table'[ColumnName],
"total",[Baseline SKU ASP Increase Effect (period)]
),
[total]
)
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.