Remove the Row context while keeping Filter context
Hi community, I have a table like the following, where Comp_x are companies belonging to the same group (owner). Table: "Transactions" My goal is to write a DAX measure that calculates internal transactions (ie: transactions between my companies only, excluding third parties), and also the "Eliminations" of such internal transactions, defining an elimination as "the minimum amount between the sum of transactions of Company vs Counterparts in the same Product Line". Therefore, the sum of Elimination column must be always zero. Examples, setting a Filter Context on "Engineering" in the report page, the expected result by Product Line on my visual should be: In the first, the minimum is represented by the sum of Costs (-30) that remains within the same product line (purchases of Comp_2 vs Comp_1), so the amount of Internal Eliminations on Revenues of Comp_1 becomes 30 as well. While setting a Filter Context on "Laboratories" in the report page, the expected result by Product Line on my visual should be: In the second example, the minimum is represented by by the sum of Costs (-55) that remains within the same product line (purchases of Comp_2 vs Comp_1), but in this case Revenues are splitted in 2 kinds. Since there's no link between Revenues of Companies, and Costs of respective Counterparts, the measure should calculate the Elimination starting from the first revenues transactions, until the accumulated limit of 55 is reached. I'm struggling to find a solution due to the presence of Filter Context and Row Context, both coexisting. The logics behind my measures is the following: [Internal Transactions] = "Calculates the Sum of Amount, by P&L Row, where Companies and Counterparts belong to the same filtered Product Line" [Internal Eliminations] = "Calculates the Minimum between the Internal Transactions of each Company vs Counterpart, within she same filtered product line, and assign such minimum value (the limit) to transactions grouped by P&L Row". Hopefully somebody could help me to figure out how to setup the measures. Thank you. Marco Download Example (xlsx)
