One Slicer, two filters

[Bobbertsan]

We have a user who wants me to create two visualizations. She wants the first visualization to filter data based on a slicer. For example, she wants to show all losses for 2021 by using a slicer bound to the loss year and selecting '2021'. However, she also wants a second visualization to show losses for the year *previous* to the value shown in the slicer in this case '2020'.  Also, my data source is an SSAS live connection, because I am having difficulty importing the data SSAS due to memory limitations.

Two questions: 

1. Am I correct in my understanding that there is no way to do this via a live connection? 

2. Is there a way to do it using imported SSAS data? If so, how? 

(OK, so that's actually three questions)

[v-yalanwu-msft · Accepted solution]

Hi, @Bobbertsan ;

Such as jdbuchanan71 said, which could create a measure when live connect. it called report-level DAX meaure；

However You can't create report level measures when authoring a report that is connected live to an SSAS multidimensional model. The only measures that are available are measures defined in the MD model.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jdbuchanan71]

That is very strange.  My work model is 100% SSAS and I can create local measures with no problem.

[Bobbertsan]

Thanks for the responses, but since I am using Analysis Services as a data-source, I can't create a measure. It's even grayed out in PBDesktop:

I was able to convince the user to accept something different, so I don't need this info any more. But thanks!

[jdbuchanan71]

You can absolutely do this with a live connection.  You just need to write a Prior Year measure.

PY Losses = CALCULATE ( [Loss Measure], SAMEPERIODLASTYEAR(DATES[Date]) )

Take a look at this article on time intelligence functions.

https://www.daxpatterns.com/standard-time-related-calculations/