Forum Discussion
Anonymous
5 years agoNot applicable
Slicer/Filter is eliminating data in chart
I'm resurrecting this issue, as my band-aid solution is not adequate. I have a table visualization where I have forecasted future sales. I created a slicer to filter out the data by differing products. When I click on a product, the forecast data (column PROJECTED GRWTH2) disappears. I believe I need to add something to DAX but not sure what that would be. DAX and image below:
PROJECTED GRWTH2 =
VAR vCurYear =
CALCULATE ( YEAR ( MAX ( 'Deep Dive'[Process Date] ) ), ALL('Deep Dive') )
VAR vCurYearSales =
CALCULATE([ACV+YTD Est.DD], ('Calendar Table'[Year] = vCurYear))
VAR vLastYearSales =
CALCULATE ([ACV+YTD Est.DD], 'Calendar Table'[Year] = vCurYear - 1 )
VAR vGrowthRate =
DIVIDE ( vCurYearSales - vLastYearSales, vLastYearSales )
VAR vYearIncrement =
MAX ( 'Calendar Table'[Year] ) - vCurYear
VAR vProjGrowth =
vCurYearSales
* POWER ( 1 + vGrowthRate, vYearIncrement )
VAR vResult =
IF ( MAX ( 'Calendar Table'[Year] ) <= vCurYear, BLANK (), ROUND ( vProjGrowth, 0 ) )
RETURN
vResult