topic Re: Need to add all function inside filter condition in DAX Commands and Tips

Need to add all function inside filter condition

sajjadkhan25 — Mon, 21 Feb 2022 13:18:34 GMT

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[Type]),
FILTER(DATESYTD(vwConsolidated2C[Fiscal Date]),MAX(vwConsolidated2C[fiscal_Mon_year])=SELECTEDVALUE(Ac_T2[FY]))
)

if i use this all function is not working how can i include in filter condition.
please help me out...

Re: Need to add all function inside filter condition

amitchandak — Mon, 21 Feb 2022 13:36:00 GMT

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]))

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.

Re: Need to add all function inside filter condition

sajjadkhan25 — Mon, 21 Feb 2022 15:23:58 GMT

Hi amitchandak sir,

but for DATESYTD i have maximum limit from slicer even dax should include that condition till where running total should happen

Re: Need to add all function inside filter condition

Anonymous — Thu, 24 Feb 2022 06:36:55 GMT

Hi sajjadkhan25 ,

I need more information to clarify your scenario.

Could you please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data?

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin