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 ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1 

thanks, this works but the problem is when I remove person_id from the table this happens ( it is grouping all the fields in the table) and I want to achive this on first screentshot in the first post

 

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