Forum Discussion
Percent Change Help
Hi- looking for help on how to calculate a simple year over year percent change. The first table shows the totals for each period in three fiscal years. Table two uses a measure to try and calculate ...
Hi eburg ,
You are using ALL('Fiscal Calendar'). In my opinion, that will ignore the [Fiscal Period] filter.
You could try using ALLSELECTED() instead.
Or add another condition: [Fiscal Period] = selectedvalue([Fiscal Period]) in the filter.
If it still doesn't work, please share the pbix so that we could test the formula.
Best Regards,
Jay