Forum Discussion
Solved
Always use sum on different granularity
Hello, I was wondering if anyone could help with following model/dax problem: Simplified, we are getting invoice data from 2 different sources, but the problem is that the granularity from th...
I would try this way:
VAR tbl = SUMMARIZE ( [yourTable], [yourTable].[InvoiceNumber], [yourTable].[InvoiceLineNumber], "_quantity", AVERAGE ( [yourTable].[Quantity] ) ) VAR result = SUMX ( tbl, [_quantity] ) RETURN result
ray_codex
Resolver II
Resolver III would try this way:
VAR tbl =
SUMMARIZE (
[yourTable],
[yourTable].[InvoiceNumber],
[yourTable].[InvoiceLineNumber],
"_quantity", AVERAGE ( [yourTable].[Quantity] )
)
VAR result =
SUMX ( tbl, [_quantity] )
RETURN
result