Sumx with 2 columns

[ngocnguyen]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[Fowmy]

@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]
)

[ngocnguyen]

@Fowmy 

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?