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

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

        If the information is sensitive please share it trough private message.