I’m working on a model with a related date and fact table and a report with a single select slicer for fiscal year. I have created cumulative measures for totals which filter on <= selectedfiscalyear and work fine.
However, I also have a user requirement to show the individual items from the selected fiscal year or before on a map. Because of the relationship between date and fact tables, a single year works fine, but not sure how to show cumulative individual results. Has anyone encountered this situation before?
I suppose I could just forget the cumulative measures and set the slicer to multi-select so the users would need to select all years they want. But then they could select non-contiguous years like FY 2022 and FY2024.
Due to the length by which this post has been active, we are tagging it as Solved.
For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.
We aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. Here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
