Sum a single value in a visual report with a Total Value

[JADG]

Hi Everyone

I'm very new in Power BI and I'm trying to learn DAX but I still have some basic issues

I have the following scenario:

- Table A with a list of Admissions Freight cost. (The freight cost is a single value for the whole admission)

- Table B all the batches for the Admissions

- Table C is the transactional table

How I can Sum Freight cost to Total Cost in the visual report?

Table A
Admissions	Freight  Cost
ADM01	800
ADM02	300
ADM03	5000

Table B
Admissions	Batch
ADM01	Batch1
ADM01	Batch2
ADM01	Batch3

Table C
Key	Prod	Batch	Cost
TableKey	Product1	Batch1	1000
TableKey	Product1	Batch1	5000
TableKey	Product1	Batch1	4000

Visual Table
Admission	Freight Cost from Table A	Total Cost (Sum of Transaction for ADM) Table B	Total + Freight
ADM01	800	10000	10800
ADM02	300	5000	5300
ADM03	5000	15000	20000

Regards

JADG

[MFelix · Accepted solution]

Hi @JADG ,

Make the following relationships:

• Table A [Admissions] (1) -> Table B [Admissions] (Many)
• Table B [Batch] (1) -> Table C [Batch] (Many)

Then create the following measure:

Total + Freight = SUM(TableA[Freight  Cost])  +SUM(TableC[Cost])

Now make you table with the following  setup:

• TableA[Admissions]
• TableA[Freigth Costs]
• TableC[Cost]
• [Total+Freight]

Check the result on the PBIX file attach.

Regards,

MFelix