Forum Discussion
Sumx with 2 columns
Hi
I have 3 table as below
Table 1: the distinct zone
Table 2: Distinct cat 1
Table 3 was connect to Table 1 by zone column
Table 3 was connect to table 2 by Cat 1 column
Now I wanna to create a measure sumx with 2 columns Zone & CAT like. So is there any way to do it?
SUMX(SUMMARIZE(Table1(ZONE ),Table2(CAT)),MYMEASURE
Hi ngocnguyen ,
What kind of expected result you want? You can provide it for my reference.
Is the following matrix the effect you want?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
ngocnguyen
Not enough information as to what the measure is supposed to calculate and the context. Anyhow, use can use a simple measure and slicer and dice as you have relationships:
Measure = sum(table3[amt])
For the requested measure:
SUMX(
SUMMARIZE(
Table3,
Table1[ZONE],
Table2[CAT]
),
[MYMEASURE]
)Thanks for your reply,
I tried your suggestion already, but it is not work.
My problem is that base on above connection, I wanna create a matrix that cotain 2 column : Zone & Cat, Then calculate sumx base on 2 above columns.
However, I stuck with creating distinct table with 2 columns like that in Sumx,
because if I created 1 column like Zone -> my measure just only:
SUMX(value (Table1(ZONE )),MYMEASURE)
But in this case , there 2 columns in 2 different table. So, how can I handle with it?
Hi ngocnguyen ,
What kind of expected result you want? You can provide it for my reference.
Is the following matrix the effect you want?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ngocnguyen ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
