Forum Discussion
Solved
Relationship with Summary Table
Hi Team, I have a table (Table A) in the following format Table B is defined as Table B = SUMMARIZE('Table A','Table A'[Signature],"Event",SUM('Table A'[Event]),"Avg Alt",AVERAGEX('Table A'...
hi Jos13
The relationship between TableA and TableB is based on [Signature], When you filter a date from date table, it will filter out [Signature] in tableA, then TableA will filter TableB only by [Signature] filed, it couldn't filter tableB by [date].
For example:
When you filter 1st may 2020, it will filter Signature is 772325 in TableA, then TableA will filter TableB by [Signature] field which it only is 772325 in TableB, so the result is 4 not 1.
For your case, you do not need a TableB, just use TableA will meet your all requirement.
Eg. you could just drag SUM of TableA[Event]
Regards,
Lin
Jos13 , did not get the need of Table B, As you got that from Table A. what is that you would not have got from Table A