Switch measure based on slicer

[jockefe]

I have a report that is using a ssas multidimensional cube as data source (live connection)

I have two amount measures (local amount and euro amount)

I want to have a slicer that I can use the controll if the local or euro measure should be used in the vizuals

Is this posdible?

[GilbertQ]

Hi @jockefe

You can do this using a disconnected table. And if you are doing this with DirectQuery I am not 100% sure if you can create the table. But if you can, follow this blog post below which explains how to achieve this.

http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

[jockefe]

---

@guavaq wrote:

Hi @jockefe

You can do this using a disconnected table. And if you are doing this with DirectQuery I am not 100% sure if you can create the table. But if you can, follow this blog post below which explains how to achieve this.

http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

---

Hi

not sure if this will work in case where I use a live connection to an OLAP mutidim database

Am I able to create the new measures?

[richbenmintz · Accepted solution]

You wil have to create the disconnected role playing dimension in the cube in the SSAS MD cube and use scoping or calculated measures to display the appropriate measure based on the currentmember of the role playing dimension

[atul9063]

Hi ,

I m facing same issue ,can you please tell how you have created scope and calculated measures in cube to display the appropriate measure based on the currentmember of the role playing dimension

[richbenmintz]

Hi @atul9063,

The following Blog Post by Marco Russo, describes in detail how to implement a time intelligence table in SSAS Multi Dimensional

http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intel...

I hope that helps

[atul9063]

Thanks

[jockefe]

---

@richbenmintz wrote:

You wil have to create the disconnected role playing dimension in the cube in the SSAS MD cube and use scoping or calculated measures to display the appropriate measure based on the currentmember of the role playing dimension

---

Thanks, I think what I need to do is to create a measure that will return different "measures" depending on a dimension value

[richbenmintz]

Hi @jockefe,

the feature that was released in the May Power BI Update allowing you to create measures against live SSAS sources does not work with MD cubes

"You won’t be able to create measures when connected to Multidimensional cubes, but we’ll consider this for a future release based on your feedback".

You will have to go back to the MD source and make the change there to support your requirement