Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Would really appreciate guidance. Here is what I want to do.
1. User selects a type of rollup that is really a column in a table.
2. After selecting the rollup, the user is able to further filter the values in the column
3. Write the DAX formulae in a way that doesn't need to change because the DAX can flex to the column selected in #1
Assuming there could be two slicers - one to choose among Rollup1 , 2 and 3 (RollupSlice). Then, another slicer (CatSlice) that, based on the Rollup selected, could allow me to choose which values to further filter the report.
I have attached samples. The sample Fact table, the Dim table and the result asuming Rollup1 is selected. Remember, though, my goal is to have the two slicer influence fairly generic DAX formula that wouldn't have to change just because the user wanted to see another rollup.
I read other posts but it just didn't seem to cover this approach. I would appreciate any help
Solved! Go to Solution.
@Anonymous solution attached, I have create new table called DIMNew, Unpivoted it and created the relationship between fact and new dim table.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anonymous set the relationship between both tables on company and use slicer from table a and table b values will be automatically calculated based on slicer. Not sure if I'm missing something here. May be you can send a sample data in excel in case you need further assistance.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Here is a link to the sample data. Feel free to edit if you like.
https://1drv.ms/u/s!AkCBPyPCuJKZtTByKlIi566lSHik
I am not a pro at DAX yet so would appreciate the paste in or the updated model to assist. But, picture writing a DAX formula based on Rollup selected. After having the slicer, I would want my DAX to be pretty generic so that referencing a rollup column would be something like Dim[CurrentlySelectedRollup] and, hence, no matter what was selected I didn't ultimately need multiple formulae (like if currentlyselected = 1 then Dim[Rollup1] else if 2.....). I can easily build a slicer that has Rollup1, 2, 3 in it. But, I am having difficulting solutioning out the generic DAX of Dim[CurrentlySelectedRollup] that will actually point to (or be loaded with) Dim[Rollup1], or Dim[Rollup2] etc.
@Anonymous solution attached, I have create new table called DIMNew, Unpivoted it and created the relationship between fact and new dim table.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2kThanks for the solution. I had seen other posts and this turns this from one-to-many to many-to-many. Maybe that doesn't matter in the long run. Because I worked in Tableau before, I used a parmeter and essentially had a column that would have alternate values depending on the Rollup slicer without restructuring the data. I am sure that had its own limitations but I was seeing how this would translate into Power BI.
Thanks for all your help and I appreciate you and the community always being responsive.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
42 | |
31 | |
27 | |
27 |