Forum Discussion
How do I return values from a selected row in a table?
I have a data table called "Goals" in a Power BI Report. A manager is going to put in data for different Businesses (see below).
Each row will have the primary key for the business and then a bunch of attributes, including name, and all the other columns are goals that the business has. So Business 1 has committed to having 1000 trips, for example. This is just something that the manager sees and has to enter manually.
There is a different worksheet with a dropdown (slicer is what I used) where businesses can choose their business.
When a business is chosen my programming needs to do the following:
Refer back to the table above and "grab" the values for each goal (like Trips).
Run an SQL over the Trips table that will pass in the key (Business ID) and count how many trips were actually completed.
From these two numbers I want two vertical bars, one for goal and one for actual.
Iterate for every goal.
I have no idea even where to start on this one.
Thanks!
4 Replies
- Greg_DecklerCommunity ChampionI feel like this post is incomplete...
- bschmiedelerFrequent Visitor
My post got mangled, half the text and two pictures were lost. I have updated it.
- daxCommunity Support
Hi bschmiedeler ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.