Forum Discussion
Chedva
Helper II
Helper IIABS by product Platform
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 ...
ChedvaHelper II
Helper IIGreg_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!!!
Greg_Deckler
Community Champion
Community ChampionWell 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