Forum Discussion

MatSantos's avatar
MatSantos
Regular Visitor
4 years ago

Sum Acumulate using 3 measures

Hi, I need some help. I have to create a sum acumulating the diference between 3 measures. These measures are from diferent files. The rule is: Evolução = PV - FAT - CART in january.  In Februar...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

MatSantos , Assume these are measures

 

CALCULATE([PV] - [FAT] - [CART] ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

 

 

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))