Matrix aggregation and filtering

[Anonymous]

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 

[Anonymous]

@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]

@Anonymous 

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

[Anonymous]

@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]

@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]

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

[Anonymous]

Hi @tamerj1  

sorry for late reply. here is a sample dataset

[tamerj1]

@Anonymous 

I don't see any link?

[Anonymous]

Hi @tamerj1 

yes, sorry. here is the link https://drive.google.com/file/d/1Bx18wxlMb-JFrtZIE-l-BU3OdCtdvkAg/view?usp=sharing 

[tamerj1]

@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] )