Forum Discussion
Matrix aggregation and filtering
Hi, I need to group values in the matrix by Source and Destination columns. How can I achive this? Thanks for any advice Previous Segment = Source Currenct Segment = Destination ...
tamerj1
Community Champion
Community ChampionAnonymous
Technically it is not possible as power bi does not support slicing by or grouping by measures. There must be a column. Actually it's not clear to me what does it mean to group by a measure if it has any meaning.
yes, ok I should explain it better . I am not sure if this is technically achivable but according to date range on slicer I want to take first (soruce) and last (destination) segment_name for each persona_identifier and then group this by source and destination with count on persona_identifier
- tamerj1
Anonymous
I can think of two possibilities. We have a good chance to do that by concatenation and a smaller chance by filter measure. Please share a sample data to work with and let me see if I can produce somthing.Thank you