Forum Discussion

keobrie's avatar
keobrie
Icon for Helper I rankHelper I
5 years ago

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 ...
DAX
Filter context
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
5 years ago

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 🙂

  • keobrie's avatar
    keobrie
    Icon for Helper I rankHelper I
    5 years ago

    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.