Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
2 years ago

How get value after selecting one visual?

Hello,

 

I need to extract and store value in measure and use it for further calculations. That value appears when I press on visual B, and it filters visual A, so I need value from visual A which appears after selecting visual B. How to implement this? I tried use selectedmeasure function in dax but not helped.

Need Help

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi Analitika ,

     

    This depens on how you model is created and on how the values from the two visuals you have selected and how they interact.

     

    Can you givce a little more context on the result you want to achieve and the way the model and visuals are setup?

    • Analitika's avatar
      Analitika
      Post Prodigy
      2 years ago

      Here is scenario, click on the one visual, filtering another 

      Before selecting:

      So I need find percentage, like for example, 4245/10625*100.  Is possible?

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi Analitika ,

         

        You need to create something similar to:

        % measure = DIVIDE( [Measure], CALCULATE([Measure], ALLSELECTED(Table[Column]))

         

        The column you should refer is the  one that you use for the intervals.