Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
11 months ago
Solved

ByPass RLS with Disconnected Table - COMPLEX ISSUE HELP

So, I have a really complex issue I am trying to resolve and hoping the community can assist with it, or tell me it is not even possible so I stop spinning my wheels on it….High Level, I have a relat...
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    11 months ago

    You can build tables on the fly inside measures, particularly now that you can use SUMMARIZECOLUMNS inside a measure.

    So you could use SUMMARIZECOLUMNS to store a table in variable, using the measure definitions above to get the correct numbers, use FILTER on that table variable to apply any additional filters, and then perform an AVERAGEX over that filtered variable.

johnt75's avatar
johnt75
Super User
11 months ago

You can build tables on the fly inside measures, particularly now that you can use SUMMARIZECOLUMNS inside a measure.

So you could use SUMMARIZECOLUMNS to store a table in variable, using the measure definitions above to get the correct numbers, use FILTER on that table variable to apply any additional filters, and then perform an AVERAGEX over that filtered variable.

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
11 months ago

johnt75 this actually may end up working.  I have tested it out in a few scenarios and it is working as of now.  If I have any issues I may reply to this thread.  Thanks for your help!