Power BI add data to a specific row in visual

[swinings]

Alright. I'm back. This project is frustrating. It is completely possible in Excel, but I am struggling in Power BI

Goal: 

To add a value to a specific row in a table visual or column visual.

Problem:

In Excel, I am able to add information to specific rows using the IF THEN function. So, on one page, I would allow my users to choose the Service/Group information. It would then populate a rate. Once done, this information would flow into the main table.

EXCEL:

I created this but the customer really likes PBI, so we are seeing if it is possible to make it work.

I am trying to do something similar in PBI using WHAT IF parameters and SELECTEDVALUE.

I have set up a WHAT IF parameter to choose their % they want to increase the value. I have also set up a filter for them to choose what specific service they want to increase. I would like to then add this information into the visual I already have set up, however, if I add it, then it affects all rows, not just the one row that was chosen. I want it to only add to the specifc row that corresponds to what was chosen.

 

What I am trying to get is if the user choses Career Discovery, then the ChosenService$ should only be in the Career Discovery row on the table visual. I have another page where I am doing something

Is this even possible?

Let me know if I should upload workbooks.

Shannon

[swinings]

EXCEL:

https://docs.google.com/spreadsheets/d/18hoJ1m4I09h38ZqCCL93AvriksF5iYKE/edit?usp=sharing&ouid=10634...

PBIX:

https://drive.google.com/file/d/1H-iVRQPCYcbyxyU9kjjQoLjeMuXU63lD/view?usp=sharing

[aj1973 · Accepted solution]

Hi @swinings 

You want to see it like this?

or like this 

if so then you need to connect the 2 tables

[swinings]

I'm leaning towards the 2nd but with all other values at $0 while CD would be $81. That way, the user can see what has been affected and what hasn't all next to each other.

[swinings]

For instance, in excel, I can create a formula to add the amount in that specific category if it says career discovery. I can't in PBI, or just don't know how.