Forum Discussion
One Slicer, two filters
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)
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.
4 Replies
v-yalanwu-msftCommunity Support
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
Super User
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/
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
That is very strange. My work model is 100% SSAS and I can create local measures with no problem.
