I am trying to show the selected filter (for e.g. year of selected date filter) on my report to keep it dynamic.
I know it is possible to do that with DAX but this is not an option with using live connection to multidimensional SSAS.
Is there any workaround for users with live connection or we are doomed to use only static labels in our report?
Any help would be appreciated.
Yes, with live connection to Multidimension Model you can't create any measure so I'm afraid you can't achieve selected values and apply these values as condition in your measure.
However, if you can change Multidimension Model to Tabular Model, you can create measures when using live connection to Tabular Model.
Thanks for your suggestion but unfortunately that is not an option for us.
We use many to many relations in our cube which is not supported in tabular model (The bi-directional cross filtering in tabular model is not actual many to many table configuration).
There is also limitation on multiple relationship between fact tables and date table (There are workaround but are not elegant at all).
So I think Microsoft has to either introduce a solution for Multidimensional SSAS users or just stop live connection for that as with these limitations there is no point using that.
Thank you very much for your suggestions, I would recommend you to submit your idea here: https://ideas.powerbi.com so that the product team can take consideration on this feature.
It is already added in ideas
More than a year ago with 1100+ vote and no words from them.
FRUSTRATING if anyone from Power BI team reading this!
Do you have a pro account? If you have, you can create a support ticket here: https://powerbi.microsoft.com/en-us/support/ so that your issue can be responsed to power bi team(PG) straightly.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.