Forum Discussion

orthain's avatar
orthain
New Member
8 years ago

Allexcept from two tables

Hi,    I am trying to solve one issue. I have several tables in my PowerBI and I am trying to create new Measure. Used tables are: 1) BusinessCase for profit 2) Products for categories   The m...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

You should just be able to add a second ALLEXCEPT function for the Product table.

 

TotalProfit = CALCULATE(
	SUM(business_case[Profit]);	
	ALLEXCEPT(	
		business_case;	
		business_case[Phase];
		business_case[OrderDate]
	);
	ALLEXCEPT(
		Product;
		Product[Category]
	)
)