Forum Discussion
Digger
4 years agoPost Patron
Substract sumarized measures
Trying to find differnet between prices but PBI sum except of minus Payments = SUMX ( SUMMARIZE ( Table, Table[_Eur_Pay],Table[id], Table[type] ), CALCULATE(MAX(Table[_Eur_Pay])) ) ...
amitchandak
4 years agoSuper User
Digger , try a measure like
SUMX (
SUMMARIZE ( Table, Table[_Eur_Prod],Table[order_products.id], "_1", MAX(Table[_Eur_Pay]) , "_2" , SUM(Table[_Eur_Prod]) )
[_1]-[_2]
)
Digger
4 years agoPost Patron