Forum Discussion

sajjadkhan25's avatar
sajjadkhan25
Icon for Helper I rankHelper I
4 years ago

Need to add all function inside filter condition

Hi Team,@amitchandak,@Samarth_18,@parry2k need to make this work, COGS = CALCULATE( SUM('vwConsolidated2C'[COGS]),all(Ac_T1[FY]),all('Type'),USERELATIONSHIP(vwConsolidated2C[Type_new],Type2[T...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

sajjadkhan25 , with help from Date table , joined with vwConsolidated2C[Fiscal Date]

 

COGS =
var _Mes = CALCULATE(SUM('vwConsolidated2C'[COGS]),USERELATIONSHIP(vwConsolidated2C[Type_new],Type2[Type]))
return
CALCULATE(_Mes,DATESYTD('Date'[Date]))

or

 

COGS =
var _Mes = CALCULATE(SUM('vwConsolidated2C'[COGS]),USERELATIONSHIP(vwConsolidated2C[Type_new],Type2[Type]))
return
CALCULATE(_Mes,,DATESYTD('Date'[Date]),all('Type')) // not sure on the need of all(Ac_T1[FY]), but you can add it here

CALCULATE(_Mes,,DATESYTD('Date'[Date]),all('Type'),all(Ac_T1[FY]))

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.