Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
common763
Helper III
Helper III

Data compiling problem utilizing the same column in a report

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 IDObject Apple
AApple Banana
APear Grapes
AOrange Orange
BPear Pear
CApple  
COrange  
DApple  
DGrapes  

 

1 REPLY 1
common763
Helper III
Helper III

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.  

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.