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

Expected ResultDestination MeasureSource Measure

"Calendar table" is not connected with "Table"

Current matrixInDateRange Measure - filter applied on matrix 

 

 

 

10 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 

    Please try

    Source =
    VAR SelectedDate =
    MIN ( 'Calendar'[Date] )
    VAR CurrentIDTable =
    FILTER ( 'Table', 'Table'[segment date] > SelectedDate )
    VAR FirstRecord =
    TOPN ( 1, CurrentIDTable, 'Table'[segment date], ASC )
    RETURN
    MAXX ( FirstRecord, 'Table'[segment_name] )

  • 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
      Community 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