Forum Discussion
Bobbertsan
4 years agoRegular Visitor
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 boun...
- 4 years ago
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.
Bobbertsan
4 years agoRegular Visitor
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!