How to Switch a measure value using a Toggle Button?

[sahooak]

Hello Everyone,

I have a requirement to create a toggle button with On and Off options.

• When the toggle is On, a column should display the value of Measure 1 + Measure 2.
• When the toggle is Off, the column should show only Measure 1.

Could you please guide me on how to achieve this?
I have created the toggle button but I dont know how to implement this.
Thank you,
AK

[KNP · Accepted solution]

Hello AK,

There are a few ways to do it. 

If you have a disconnected table like...

You can then reference the selection in the measure...

If you were thinking about using bookmarks, I would recommend avoiding them. They create more hassle than they're worth.

[v-sgandrathi]

Hi @sahooak,

Has your issue been resolved?
If the response provided by @KNP  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-sgandrathi]

Hi @sahooak,

Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.

Looking forward to your response.

[KNP · Accepted solution]

Hello AK,

There are a few ways to do it. 

If you have a disconnected table like...

You can then reference the selection in the measure...

If you were thinking about using bookmarks, I would recommend avoiding them. They create more hassle than they're worth.

[sahooak]

Thank you for you help. Can have Toggle button for this requirement

[sahooak]

Thank you for you help. Can we use Toggle button for this requirement

[KNP · Accepted solution]

Check out these videos...

https://youtu.be/7M8LAQX7dWE

https://youtu.be/IsGY7RjKba0