exclude from measure
1 Topic
Measure excluding defined intersection.
Hi, I have the following data and need a measure that excludes the intersection of Account "A2" and Branch "Br1". The sum of the measure should therefore = 100 for the two months. Account A1 A2 A3 Branch Br1 Br2 BranchAccountMonthAmount Br1 A1 Jan 10 Br1 A2 Jan 1000 Br1 A3 Jan 10 Br2 A1 Jan 10 Br2 A2 Jan 10 Br2 A3 Jan 10 Br1 A1 Feb 10 Br1 A2 Feb 1250 Br1 A3 Feb 10 Br2 A1 Feb 10 Br2 A2 Feb 10 Br2 A3 Feb 10 Thank you in advance.Solved570Views0likes2Comments