Forum Discussion
Returning a static column value based on another column
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...
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