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 ...
Need Help
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.

      • Analitika's avatar
        Analitika
        Post Prodigy
        2 years ago

        I have tried this but it calculates of grand total not total per range. So it is wrong. I need percentage