Change the value of one measure using another

[judeab_07]

Hi Guys,

I'm new to PBI and trying to figure out how to use measures. I'm trying to change the value of one measure, using another. Hope the measure I attempted to write will make it clear.

SlicerResult = IF(HASONEVALUE(ToggleTable[Value]),

                                                                    IF(VALUES(ToggleTable[Value]) = "Yes",[HideVisual]=0,[HideVisual]=1))

Basically I'm trying to use a slicer as a toggle button to hide or unide a visual. Bookmarks do not fit what I am looking for.

Thanks in advance,

Jude

[judeab_07]

Hi,

thank you for your response.

Here's what I'm trying to do. If I select "yes" the value of the card should change to 0 and if I select No, it should chnage to 1.

The value on the card is a measure called HideVisual, which I would like to change using the slicer.

Hope this helps.

[vanessafvg]

it does help just not sure why you are doing it the way you are doing it.  

you might try it a different way ?

HideVisual=
IF (
    NOT ( ISBLANK ( ToggleTable[Value] ) && ToggleTable[Value] ) = "Yes",
    0,
    1
)

[judeab_07]

Hello,

That's because I am already assigning value to the measure HideVisual earlier.

HideVisual = IF([CheckFilter],1,0)

Here I'm checking if a filter has been applied on some visuals, and then the value will be given accordingly.

With this new measure I want to change the already set value of HideVisual.  Is this even possible?

Many thanks!

[vanessafvg]

Providing some sample data with the expected solution to work through this would be the best way to figure that out.  Its really hard to give a solution without understanding how the data looks.

[vanessafvg]

can you in pictures explain exactly what you are trying to do, and what is not currently working?

Provide an example with some data so its clear what the solution is you are looking for.