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.
A customer asked me for help with something and I need some advice. Problem detailed below.
There are multiple rows in the dataset. One column is ID and an ID can have more than one Object which is a separate column.
The end-user is trying to do some predictive analytics. What they want to see is if an object is selected in the slicer, for example Orange, they also want to see all the Objects tied to that specific ID (want to see orange and other values in the same column). The problem seems circular to me as once I click on the 'Orange' slicer, it omits the other Objects in that column. Hope I am making sense here. I created a mock lookup of what I am dealing with.
Dealing with the below, if the end-user selects Apple in the slicer, they would then see
Apple (for ID A),
Pear (for ID A),
Orange (for ID A),
Apple (for ID C), etc.
DATASET | SLICER FOR Object Column | ||
Facility ID | Object | Apple | |
A | Apple | Banana | |
A | Pear | Grapes | |
A | Orange | Orange | |
B | Pear | Pear | |
C | Apple | ||
C | Orange | ||
D | Apple | ||
D | Grapes |
Basically the end user wants to know when Apple appears in a row, what % of the other values occur also. So if we have a total count of 80 for Apple, and Orange occurs 10 times under the same ID and Grape 10 times, they want to display that grape and orange showed up 10% of the time when an ID was associated with Apple. Its confusing and thinking the data isnt setup properly to do this but wasnt sure if there was some type of DAX formula that could address this. Sounds more like a python program to do this.
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 |