Hi @Paul Mauriello ,
Welcome to Microsoft Q&A!
Please refer to below links:
Assign bucket types dynamically with MDX and dynamic sets in Analysis Services
How to create buckets on measures from 2 fact tables, i.e variance between actual and budget coming from separate fact tables
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.