Forum Discussion
Filter visual using dynamic aggregate calculation that references other slicer defined values
I think I've found my solution!! I'm yet to implement it, but in principle I can't see why it won't work: Integrate a Power App into the Power BI report that writes user input back to the data source and updates with Direct Query in real time: https://www.youtube.com/watch?v=us0hPFwQ4Zs
Will report back with anything noteable once I've put this into practice.
You cannot influence calculated columns from measures. That is a fundamental design decision/limitation in Power BI. You may need to go back to using Excel.
Thanks for your response. I am accutely aware of that but it is not an option to go back to excel due to a number of other mission-critical reasons. So I am trying to think outside the box here (and asking the community for help doing so), to find a way of achieving my desired result (first paragraph of my question) that bypasses Power BI's inability influence calculated columns from measures.