How to get count by group?

[nutdiablo]

Dear Everyone,

Sorry for my bad English. I got Table Revenue and Location as picture below.
When I merge 2 tables together revenue got duplicated. So I need column D so I can divine the number back to normal.
Please advice.

[nutdiablo · Accepted solution]

I have found the solution.

I user merge with aggregate then merge again to break it into details.

[Anonymous]

What is this, a DAX- or PQ-related question? If it's PQ, please find the forum on PQ.

If it's about DAX... then what do you mean by "merging tables"?

Thanks.

Best

Darek