Total revenue from overlapping customers Line of business

[kaloo35]

Hi All,

I have the following table as a data source in Power BI:

Calendar year	Account ID	Account Name	Line of Business	Product Line	Amount	Overlapping Line of Business
2020	0001	Name1	Line1	01	79	yes
2020	0001	Name1	Line2	03	92	yes
2020	0001	Name1	Line2	04	21	yes
2021	0001	Name1	Line2	05	11	yes
2020	0002	Name2	Line1	01	54	no
2020	0002	Name2	Line1	02	40	no
2021	0003	Name3	Line1	02	89	yes
2021	0003	Name3	Line2	03	84	yes
2021	0003	Name3	Line2	04	62	yes
2021	0003	Name3	Line2	05	35	yes
2021	0003	Name3	Line1	01	69	yes

What I am trying to achieve here is to consolidate the overlapping Sales accross Product line.

definition: an overlapping happens when a customer bought Product line from both "Line of business" at least once.

Here is the matrix table I will be willing to build:

only overlapping amount per Product Line are consolidated below

Explanation overlappling Line1/01 & Line2/03 - Overlap = 79 + 69 =148
Sum of Sales of PL01 in case of overlapping if PL03 already sold to the considered account

Any chance a Super User may have a look into the request  - It will be a great help

Br

Thomas

[Anonymous]

Well... Still not clear to me. Sorry 😞 Maybe somebody else will be able.

[Anonymous]

@kaloo35 

Your requirement is not clear. Please re-phrase the problem so that people can understand it.

Here's something to get you started: https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-... 

Thanks.

[kaloo35]

Hi @Anonymous - yes of course I am ading some more explanation + the excel + .pbix

In case of any more details needed - do not hesitate many thanks