Forum Discussion
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 ID | Object | Apple | |
| A | Apple | Banana | |
| A | Pear | Grapes | |
| A | Orange | Orange | |
| B | Pear | Pear | |
| C | Apple | ||
| C | Orange | ||
| D | Apple | ||
| D | Grapes |
1 Reply
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.
