Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Wong calculation with calculate function (deja vu?)

Hi! I have a problem with the calculate dax function, and i am pretty sure it is about filering within the formula, but since i am not used to DAX, i can't figure out how to do it right. This is for...
CALCULATE
DAX
ChiragGarg2512's avatar
ChiragGarg2512
Icon for Solution Sage rankSolution Sage
3 years ago

In the DAX expression, the expression is written as product of sums instead it should be sum of products.

 

It should be Calculate(sumX(FactTable,FactTable[Workload]*related(TeamsComposition[capa])),.....)  instead of Calculate(sum(FactTable[Workload])*sum(TeamsComposition[capa]), .....).

Only possible if the relationship is one to many.

 

If the problem continues, pleae share sample data.