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
    10 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

Thank you for the input.  Unfortunately, this solution does not work because once we aggregate it and not look at each individual CompData Facility, the comparison is no longer at an individual level and the Prior Year Sales and Qty are now aggregated and there are no 'comps'

  • ryan_b_fiting's avatar
    ryan_b_fiting
    Post Patron
    10 months ago

    It does not appear that anything has changed in this new file.  The results remain the same

    If I choose Show Sales Comps it should be 2 facilities (if I am showing facilities) and total PriorYearSales of 310,000.

     

    However, we are not showing it on a Comp Facility by Facility Bases, we need to filter out the facilities that are not true comps and then aggregate/average.  But when I remove the facilityKey from the table, the total becomes the sum of ALL 3 facilities which is wrong.