Calculated Column HELP! Variable from Slicer

Hi Luke-Howells ,

It seems that you want to get dynamcially get the results based on selections in slicer.

If so, you need to create measures instead of calculated columns since calculated columns are static and could not be dynamically changed.

In addition, without some dummy data , it's not easy to clarify your scenario, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

Refer to:

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.