New PowerBi user here. I have a dynamic table with data like this:
| Category | Gross Margin | Gross Margin per unit | Target per unit |
| A | 3000 | $3.25 | ? |
| B | 200 | $5 | ? |
| C | 500 | $7.20 | ? |
| D | 100 | $15 | ? |
In the 4th column I would like to return a static Target Per Unit value depending on the category. Aside from the exception described below, this value would not be affected by slicers; it is set during the annual budgeting process.
One wrinkle is that the data is referencing two consolidated companies, and that choosing one company over another in that particular slicer would need to change the Target per unit, as the Target is different per company for each category.
Thanks in advance for your time and help in this.
