I have a table called Sales with columns Fiscal Year, Fiscal Quarter, Region, Country, Partner, Budget and Sales.
I wanted to create a measure that sums (Sales - Budget) by Partner, only when Sales > Budget (“UpSales”). I will then filter the other columns Upsell.xlsx (15.8 KB)
in a pivot table.
I tried to create something like this so I will be able to sum the “UpSales” by Country and Region.
CALCULATETABLE(
SUMMARIZE ( Sales,
Sales[Partner],
“UpSales” , [Sales] - [Budget]
) [Sales] > [Budget] — here I got the error " CALCULATE’ has been used in a True/False expression]" —
I am sending a sample of the table and the expected result.
Hi @cesartozzi, did the response provided by Ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!