Returning a static column value based on another column

[gmichalec]

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. 

[v-eqin-msft]

Hi @gmichalec ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @gmichalec ,

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Like what's the calculated logic of Target per unit? What do you mean it will not be affected by a slicer? The calculated column is indeed static, it will not be changed by selection in slicer. And please show us your expected outputs...

Please kindly refer to the blogs to know

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[amitchandak]

@gmichalec , Not very clear,

You can create a new column like

Switch( [Category],

"A", 50,

"B", 20,

"C", 30,

"C", 40 )