Measure edit interactions

[gabreila]

Ahoj,

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

[v-robertq-msft · Accepted solution]

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:

2. Create a measure:

Measure =

SWITCH(

SELECTEDVALUE('Slicer'[Name]),

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

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

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.

[gabreila]

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

[v-robertq-msft · Accepted solution]

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 · Accepted solution]

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:

2. Create a measure:

Measure =

SWITCH(

SELECTEDVALUE('Slicer'[Name]),

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

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

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]

@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.