Year over year calculation with multiple slicers

Hi acrinard  -Your YOY Percentage Change New 2 measure might be returning blank or zero as denominator is vlaue returns blank. 

Base Year New =
VAR SelectedBaseYear = SELECTEDVALUE('Tag Unpivot'[Request Date 2].[Year])
RETURN
CALCULATE(
COUNTA('Tag Unpivot'[Request ID]),
'Tag Unpivot'[Request Date].[Year] = SelectedBaseYear
)

Measure for updated Comparison :

Comparison Year Request Count New =
VAR SelectedComparisonYear = SELECTEDVALUE('Tag Unpivot'[Request Date].[Year])
RETURN
CALCULATE(
COUNTA('Tag Unpivot'[Request ID]),
'Tag Unpivot'[Request Date].[Year] = SelectedComparisonYear
)

final calculation should be:YOY Percentage Change measure

YOY Percentage Change New 2 =
VAR BaseYearCount = [Base Year New]
VAR ComparisonYearCount = [Comparison Year Request Count New]
RETURN
IF(
BaseYearCount > 0,
DIVIDE(ComparisonYearCount - BaseYearCount, BaseYearCount)
)

Hope this helps.

Thank you, rajendraongole1 , for your response.

Hi acrinard,

Please find below the DAX measures that may help in resolving the issue:

Base Year New =

VAR SelectedBaseYear = SELECTEDVALUE('Tag Unpivot'[Request Date 2].[Year])

RETURN

CALCULATE(

COUNTA('Tag Unpivot'[Request ID]),

'Tag Unpivot'[Request Date].[Year] = SelectedBaseYear,

ALLSELECTED('Tag Unpivot'[Tag]),

ALLSELECTED('Tag Unpivot'[Tag (groups)])

)

Comparison Year Request Count New =

VAR SelectedComparisonYear = SELECTEDVALUE('Tag Unpivot'[Request Date].[Year])

RETURN

CALCULATE(

COUNTA('Tag Unpivot'[Request ID]),

'Tag Unpivot'[Request Date].[Year] = SelectedComparisonYear,

ALLSELECTED('Tag Unpivot'[Tag]),

ALLSELECTED('Tag Unpivot'[Tag (groups)])

)

YOY Percentage Change New =

VAR BaseYearCount = [Base Year New]

VAR ComparisonYearCount = [Comparison Year Request Count New]

RETURN

IF(

AND(BaseYearCount > 0, NOT ISBLANK(BaseYearCount)),

DIVIDE(ComparisonYearCount - BaseYearCount, BaseYearCount, 0),

BLANK()

)

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Thank you.