Hi, currently we are using Power BI as the semantic layer because it allows us to build custom measures to do aggregates and business logic calculation, and provides native connection to Excel. I am thinking to move these logics to Databricks using SQL view, however I am wondering if the dynamic measure calculation based on filter selection can still be achieved in Excel, e.g. dynamically change sales amount based on currency filter? Thanks.
