Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gabreila
Frequent Visitor

Measure edit interactions

Ahoj,

Potrebujem pomoc, ak sa v takom prípade dá vytvoriť opatrenie,
ďakujem
Gabriela
Measure.png

2 ACCEPTED SOLUTIONS
v-robertq-msft
Community Support
Community Support

Hello, @gabreila

According to your description, I suppose you want to make the measurement show "1" when the name is selected by the cutter, you can follow my steps:

  1. Create a [Slicer] table:

屏幕截图 2020-11-10 142718.png

  1. Create a measure:
Measure =

SWITCH(

SELECTEDVALUE('Slicer'[Name]),

MAX('Table'[Name]),1,0)

  1. Create a slicer and table, place fields like this:

v-robertq-msft_1-1604989569326.png

v-robertq-msft_2-1604989569332.png

And you can get anything you want.

You can download my test pbix file here

If this result is not what you want, you can publish some sample data (without sensitive data) and the expected result.

How to get answers to your question quickly

Best regards

Qin Community Support _Robert Team

If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

Hi, @gabreila 

If this reply does help you to solve the problem, would you like to accept it as a solution?
Thanks in advance!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
gabreila
Frequent Visitor

Hello,
thank you very much,
that's exactly what I wanted.
Gabriela

Hi, @gabreila 

If this reply does help you to solve the problem, would you like to accept it as a solution?
Thanks in advance!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft
Community Support
Community Support

Hello, @gabreila

According to your description, I suppose you want to make the measurement show "1" when the name is selected by the cutter, you can follow my steps:

  1. Create a [Slicer] table:

屏幕截图 2020-11-10 142718.png

  1. Create a measure:
Measure =

SWITCH(

SELECTEDVALUE('Slicer'[Name]),

MAX('Table'[Name]),1,0)

  1. Create a slicer and table, place fields like this:

v-robertq-msft_1-1604989569326.png

v-robertq-msft_2-1604989569332.png

And you can get anything you want.

You can download my test pbix file here

If this result is not what you want, you can publish some sample data (without sensitive data) and the expected result.

How to get answers to your question quickly

Best regards

Qin Community Support _Robert Team

If this post helps,then consider Accepting it as the solution to help other members find it faster.

amitchandak
Super User
Super User

@gabreila ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!