Forum Discussion
DAX Filter Context Issue
I have a Power BI Table with a category and a single calculated value. In order to properly calculate the value, the underlying recordset needs to be filtered and ranked dynamically based upon user ...
keobrie You need to share your PBI file to get solution for this problem, it is impossible to tell if you are referring to a Meaure or a Column in your variables 🙂
Unfortunately the model itself is confidential and stored in an SSAS Tabular Database. That said, your point is understood. I am going to try to build out a "test" environment in PBI Desktop and post the test environment. It may take me some time to get to it this week. In the meantime, I used T-SQL to build out a different dataset that works for this specific use-case but I'd really like to see the solution handled dynamically in PBI.