Using FIRSTDATE in measure for percent change (index 100%) line graph

[Anonymous]

I'm putting together a percent change (index 100%) line graph. I'd like to be able to adjust the start date of the graph and have the chart adjust to 100% for the new date. 

Below is the graph. 

Below is my dax. I can't figure out how to make my start date adjust based on a slicer. I can get the measure to work using a hard coded date, but not if I use FIRSTDATE. Writing 'Associate Fact Table'[File Date] = FIRSTDATE brings back a True/False error. 

Associate Perc Change = ((CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]))

-

CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]), 'Associate Fact Table'[File Date] = DATE(2018,7,01))))

/

CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]), 'Associate Fact Table'[File Date] = DATE(2018,7,01))

+

1

Any suggestions on how I can make the chart adjust based on a date selection? I'd like to at least be able to start the chart at 1/1/19 and 1/1/20.

[nvprasad]

Hi,

Have you tried using SelectedValue measure to get the slicer selection? you can use the result into your formula instead of a hard-coded date.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[Anonymous]

Thank you for the suggestion. I didn't have luck with SelectedValue. I still receive the True/False error when I put it in dax. Dax I used is below:

Associate Perc Change = ((CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]))

    -

CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]), 'Associate Fact Table'[File Date] = SELECTEDVALUE('Associate Fact Table'[File Date],DATE(2018,7,1)))))

    /

CALCULATE(SUM('Associate Fact Table'[ActiveStatusIs1]), SELECTEDVALUE('Associate Fact Table'[File Date],DATE(2018,7,1)))

Looking at examples of how to use SelectedValue, I'm not sure how to get it to fit here.