Hello, just to note I meant to put VALUES not RELATED in the title, but posted and edit won't let me change it. (edit: changed for you 
)
Just a question regarding what's actually happening,;
I have a formula ;
Over Product:=SUMX('Product',
('Product'[Price]-'Product'[Cost])*
CALCULATE(SUM(Sales[Sales])) ) , This works, so I thought to avoid any duplicate price, cost values ( there aren't any ) I'd
use the following,
Copy of Over Product:=SUMX('Product',
(VALUES('Product'[Price])-VALUES('Product'[Cost]))*
CALCULATE(SUM(Sales[Sales])) ) But this does not work?
as VALUES is just returning a single
column table I'm not sure why, all I can think is that the two returned tables are called sales and cost and not recognized?
Any suggestions,
Richard
)Just a question regarding what's actually happening,;
I have a formula ;
Over Product:=SUMX('Product',
('Product'[Price]-'Product'[Cost])*
CALCULATE(SUM(Sales[Sales])) ) , This works, so I thought to avoid any duplicate price, cost values ( there aren't any ) I'd
use the following,
Copy of Over Product:=SUMX('Product',
(VALUES('Product'[Price])-VALUES('Product'[Cost]))*
CALCULATE(SUM(Sales[Sales])) ) But this does not work?
as VALUES is just returning a single
column table I'm not sure why, all I can think is that the two returned tables are called sales and cost and not recognized?
Any suggestions,
Richard
Last edited by a moderator:
