Measures Parameter

[Anonymous]

Hello,

Could you please answer the following question: ' how can I create a parameter in order to select a measure?'

In other words, I would like to create a parameter that contains Sales - Profit - Cost and Quantity, so when I select Sales, my dashboard will be showing Sales by X dimension, or when I choose Profit, the dashboard will be showing Profit by X dimensions.

Thank you in advance,

Rita

[Anonymous]

Hi, You should consider using bookmarks for this. Simply save the view you wish to have as a bookmark, create a new button and assign this action -> bookmark to your newly created bookmark. This is a bit of a hassle, but it's more (end) user friendly.

[Anonymous]

Hello TijnOnline,

Thank you for your help, but I guess you got me wrong; below is a snapshot of what I'm looking for:

You have a parameter named Select a measure that contains Nb of users, cost sales measures when I click on Nb of users, the charts will show me Nb of users by Machines and Trigramme, without navigating to other dashboards.

Thank you in advance,

Rita

[PaulDBrown · Accepted solution]

@Anonymous 

You might try:

IF(SELECTEDVALUE(‘Select a measure’[column]= “Nb of users”, [Nb of users by Machines and Trigramme], [your other measure]) 

(or the appropriate measures)

there cannot be a relationship between your ‘Select a measure’ table and the dataset, and 

 better to make the slicer “Single Select”

[Anonymous]

Hello,

Thank you for your Help !!!

Rita