Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous 

In the first screenshot, does each row represents on Id?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1 No, this is grouped by source and destination and  Total Users = count(persona_id)

 

this is not easy to implement because slicer can't affect on calculated table so I've created this two measures - source and destination. I am not sure how to show only these two measures on matrix/table

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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