Forum Discussion
Targeta with Values
@mahoneypat've changed the formula to make it more efficient. Thank you
How can I put the VTA1 measure on a table on another sheet and give me the same value? It doesn't work.
https://drive.google.com/file/d/1wcjIvxpX4UYDb4SL6AEhNwNDtFpsSaQ0/view?usp=sharing
This is an example of how to write a measure expression to simulate that table visual all in one measure. It uses a SUMMARIZE using the same columns, and then it calculates the VTA1 measure for each row, then sums it all up and should give the same result. You will need to add any of the same visual or page filters from that table to match.
NewMeasure ?
SUMX (
SUMMARIZE (
'SALES ORDERS',
'SALES ORDERS'[Sales Order No],
'SALES ORDERS'[Customer Name],
'SALES ORDERS'[Confirmed Shipping Order]
),
[VTA1]
)
Regards,
Pat
@mahoneypat doesn't work.
if I add that measure on the sheet where I have the other calculations if it works, but when I add the measure in a table on another sheet (in the TOTAL sheet); gives me 0 values.