Correct data for export

[BartVlek]

Hello Forum,

I have a simple dashboard with two tables with information about orders. In the first table there is the customer data, in the second the articles sold. They are joined by the OrderId.
For our financial administration  I need to make an export file with requiered data from the orders.
When one order has more order lines the shipping costs are placed after each line, while they are for the complete order.
The FA needs the seperate order lines, but of course the shipping costs may only be calculated once.

How would you solve that? Thanks in advance for your help !

[Pragati11]

Hi @BartVlek ,

Can you please add more detail to your query like sample data, data model, their relationships, etc.?

The current scenario doesn't help at all in answering your question.

Refer following article on how to get your question answered correctly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati

[BartVlek]

I would love to. How can I add files to a post?

[BartVlek]

[v-eachen-msft]

Hi @BartVlek ,

You could show your expected results here with screenshots or tables. 

According to your image above, is the "Porto" calculated only once for each ID in subsequent calculations? You could use the average value like :

AVG =
CALCULATE (
    AVERAGE ( 'Table'[Porto] ),
    ALLEXCEPT ( 'Table', 'Table'[orderId] )
)