Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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
Cannot make a UNION cause tables are different...
User | Count |
---|---|
144 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |