I have a straight table with 2-10 dimension values (user can select as many as they want to display) plus a measure for each fiscal year. I want my table to respect any filters applied to dimensions EXCEPT FOR the year dimension, I want each year column to display that correct amount for that year. I have other elements on page that do respect the year filter.
is there a way to accomplish this without using possible values for every potential dimension selected in set analysis?
i also want to avoid using a pivot table in this instance, if possible.
I'm not sure if I read this correctly - I originally responded and then deleted it because I think I misunderstood - but it sounds like what you're trying to do is e.g.
Sum({< [Fiscal Year] = {2022} >} YourMeasure)
This would respect all selections and dimensions but always show data for Fiscal Year 2022 regardless of selections that were made on that field (if any).
I'm not sure if I read this correctly - I originally responded and then deleted it because I think I misunderstood - but it sounds like what you're trying to do is e.g.
Sum({< [Fiscal Year] = {2022} >} YourMeasure)
This would respect all selections and dimensions but always show data for Fiscal Year 2022 regardless of selections that were made on that field (if any).
Thank you, that's what I thought, but it wasn't working. But after your post saying it SHOULD work I realized there was a problem with my data model that I was able to fix. Thank you for the help!
