Forum Discussion

Ani26's avatar
Ani26
Icon for Helper III rankHelper III
6 years ago

filter expression in Calculate function is not getting evaluated.

Hi Team, Need your small assistance. I have one DAX expression as below, Variance = var dyear = [vDefaultYear] var dquarter = [vDefaultQuarter] RETURN CALCULATE(SUM(SalesForce[New Actual]),Fi...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Ani26 

 

Can you share the expression for  [vDefaultQuarter] ?

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

Ani26's avatar
Ani26
Icon for Helper III rankHelper III
6 years ago

Hi Mariusz 

Sure!!
Here it is.

vDefaultQuarter = CALCULATE(MAX(Fiscal_Calendar[Fiscal_Quarter]),FILTER(Fiscal_Calendar,Fiscal_Calendar[Fiscal_Year] = [vDefaultYear] && Fiscal_Calendar[DefaultQuarterSeq] = [vDefaultQuarterSeq]))

vDefaultQuarterSeq = max(Fiscal_Calendar[DefaultQuarterSeq]) 

vDefaultYear = Year(MAX(SalesForce[vFilterDateCalculation]))

Kindly let me know if any additional information required.

 

Thanks,
Ani