Forum Discussion

gabreila's avatar
gabreila
Frequent Visitor
5 years ago
Solved

Measure edit interactions

Ahoj, Potrebujem pomoc, ak sa v takom prípade dá vytvoriť opatrenie, ďakujem Gabriela
  • v-robertq-msft's avatar
    5 years ago

    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.

  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.