March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I have the following Dataset:
Platform | Product | Act (Sum measure) | Forecast (Sum Measure) | ABS (ABS = ABS('Actual Consol'[Act]-[Forecast])) |
A | A1 | 80 | 20 | 60 |
A | A2 | 40 | 56 | 16 |
B | B1 | 120 | 150 | 30 |
C | C1 | 5 | 1 | 4 |
C | C2 | 1 | 0 | 1 |
C | C3 | 3 | 4 | 1 |
C | C4 | 4 | 7 | 3 |
C | C5 | 95 | 81 | 14 |
I would like to calculate the ABS of the product platform but according to each product.
Platform | Act | Forecast | ABS | ACC ABS | ABS by Product - want |
A | 120 | 76 | 44 | 29 | 76 |
B | 120 | 150 | 30 | 29 | 30 |
C | 108 | 93 | 15 | 29 | 23 |
Total | 348 | 319 | 29 | 29 | 129 |
Thanks!
Hi @Chedva ,
Could you please consider sharing the relationship and fields between these tables or a sample .pbix file for further discussion? I have created the table relationship like this and create a measure to get your expected output but not certain your dataset relationship:
ABS by product =
CALCULATE(
SUMX(
'act table',
[ABS]
),
ALLEXCEPT(
'act table',
'act table'[Platform]
)
)
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Greg_Deckler @az38
ABS is a measure, not in a specific table. the table I showed is a table in the report section.
Act - a measure - that sums the measure from the actual table
Forecast - a measure that sums the forecast from forecast table.
Matrix_Lookup is a table with relationship to both actual table and forecast table on the product. and it has the platform there as well for slicing the report.
Hope I was clear - thanks for you help!!!
Well then this looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
70 | |
68 |