Forum Discussion
Many to Many - Measure
You can refer to the following DAX formula to create a measure, which creates a virtual table to merge tables Sales and Type, and returns the result you want.
Measure = VAR t = FILTER ( CROSSJOIN ( SELECTCOLUMNS ( Sales, "sale_type", [type], "id", [id], "month", [month] ), 'Type' ), [sale_type] = [Type] && [month] = 3 ) RETURN SUMX ( FILTER ( t, [SubType] = MAX ( [SubType] ) ), [Value] )
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can refer to the following DAX formula to create a measure, which creates a virtual table to merge tables Sales and Type, and returns the result you want.
Measure = VAR t = FILTER ( CROSSJOIN ( SELECTCOLUMNS ( Sales, "sale_type", [type], "id", [id], "month", [month] ), 'Type' ), [sale_type] = [Type] && [month] = 3 ) RETURN SUMX ( FILTER ( t, [SubType] = MAX ( [SubType] ) ), [Value] )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi v-juanli-msft ,
in this solution we dont need the "many to many" relationship?
v-juanli-msft is there another solution
v-juanli-msft wrote:Yes.
Best Regards
Maggie
using the logical relationship?Thanks for your time!