Aggregate Calculation Logic Help

[Anonymous]

Trying to transition to PowerBI after having used Tableau for years and struggling to wrap my head around aggregation logic. I understand that a calculated column will aggregate at the table row level while a calculated measure will be dynamic at the displayed aggregation. However, this logic doesnt appear to always hold up as I will illustrate in this example. Im trying to fill in the gaps of my concept comprehension.

In this example I'm expecting my 'Component KG' to multiply out via simple arithmetic at the displayed level of aggregation. I get close to what im looking for, but not exactly. Any idea what im missing? Thanks.

[Anonymous]

HI @Anonymous ,

I don't know why you are facing this mismatch. But when I tried, it worked for me with out any issue.

My quick Measure below:

Average of AVG x Average of Column2 = 
AVERAGE('Table (2)'[AVG]) * AVERAGE('Table (2)'[Column2])

My output:

Give  try with a quick measure.

Thanks,

Tejaswi

[Anonymous]

Tried creating the same output through quick measure and still get the same 832.98 instead of the expected 841.6. Does the order of operations for the arithmetic calculation do the multiplication at the row level before aggregating and taking an average?

Maybe worth pointing out that the 1 line for the Styrene 500 shown above is average aggregation for maybe 10,000 lines of production data. Hard for me to validate how BI is coming up with the 833 b/c the underlying table is ~20M lines large.

[Anonymous]

Hi @Anonymous ,

Check if any filters are applied. ( Page level. report level. Visual level filters).

Thanks,

Tejaswi

[Anonymous]

Check if any filters are applied. ( Page level. report level. Visual level filters).

---

No page level filters, visual level filters are all set to (All)