Insert a row to a column (which is a sum of another table column)

[gianmarco]

Dear All,

I have two tables:

Table A (clients-revenues)

Client	Date	Invoice	Total
x	01/01/23	1	300
y	02/01/23	2	600
x	02/01/23	3	400

Table B (special client revenue)

Special Client	Date	Total
z (always the same)	03/01/23	200
z (always the same)	04/01/23	300

I came up with a visual which sums TABLE A's revenues by grouping clients per unique row:

Client	Total revenue
x	700
y	600

What I want to achieve now is bringing in the same visual one new row which is my single special client's revenues(client z):

Client	Total revenue
x	700
y	600
z	500

Thank you for your help

gianmarco

[Arul]

@gianmarco ,

try this in calculated table,

Total cost = 
VAR _total = SUMMARIZE(
    'Table A',
    'Table A'[Client],
    "Total Revenue",SUM('Table A'[Total]))
VAR _lastrow = SUMMARIZE(
    'Table B',
    'Table B'[Special Client],
    "Total",SUM('Table B'[Total]))
VAR _result = UNION(_total,_lastrow)
RETURN _result

Thanks,

Arul

[gianmarco]

Cannot make a UNION cause tables are different...