Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

How to Create a Measure that works Against Whatever the Selected Row Is?

I have a simple table in Power BI Desktop:

       | Total | YTD
=======|=======|======
Sally  | 100   | 20      
Bob    | 15    | 3
Joe    | 47    | 36
=======|=======|======
Totals | 162   | 59

I also have a Gauge for this data and I’d like to be able to have the gauge show only the data for the selected row in the table. That part works, but I need to have the gauge have a target that is .95 of the value in the Total column for the selected row. For example, if the user selects the Bob row, I need the gauge to use 14.25 (15 * .95) as the target. But if the user selects the Sally row, the Gauge target should be 95 (100 + .95).

I believe that I need a measure to make this work, but I am stuck on how to set the measure up so that it will be dynamic:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

Target = .95 * [What would go here?]

Thanks for your guidance.

>Solution :

Target = 0.95 * SUM('Table'[Total])
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading