Re-reading my question, you're right... that's not answerable as stated. I'm doing this in PowerBI / DAX, so I have a simple star schema with Customers and Sales ...
CREATE TABLE Customer(
CustomerID INT IDENTITY(1,1),
CONSTRAINT pkCustomer PRIMARY KEY (CustomerID));
CREATE TABLE Sales(
CustomerID INT NOT NULL,
SaleDate DATE NOT NULL,
ProductID INT NOT NULL,
Quantity INT NOT NULL,
CONSTRAINT fkCustomerID FOREIGN KEY CustomerID REFERENCES Customer(CustomerID));
Say I want to compare a single customer (my company/us) to all other customers in the Customers table, so my company *always* on the pivot. I could create a measure to do it:
Total Units = SUM(Sales[Quantity])
and then filter for just the customer I want in another measure:
Customer12 Total Units = CALCULATE([Total Units],CustomerID=12)
The rub is that I have a ton of measures and several fact tables, and I want to basically force "Customer12" to show up in all of the visuals. I tried using UNION() to append "Customer12" to the selected group of customers, but no joy. Something like
Do I have to do something like use FILTER() to create return two tables (one with just Customer12, one with everyone else), and then union those back together?