Matrix Values (show all)

[deefunk1981]

Hi,

I am having an issue I am hoping someone can help me with.  I am using a dataflow to create a matrix / planning view.  I have the matrix setup and attached a snapshot of it.  I have concatenated several columns into a column called full notes.  This then displays all the details of the job the team is working on each day of the week.  However, our teams usually do more than 1 job a day and the matrix can only show First, Last or Count whereas I need it to show all jobs for each day in the format shown below.  Hopefully there is an easy solution to this but I cannot find it.  

Many Thanks,

David

[Anonymous · Accepted solution]

Hi @deefunk1981 ,

Is the output you expected?

If so, please try:

Measure = 
var _t=SUMMARIZE(FILTER(ALL('Table'),[Team Name]=MAX('Table'[Team Name])),[Full Notes])
return CONCATENATEX(_t,[Full Notes]," , ")

Measure 2 = 
var _first=CALCULATE( FIRSTNONBLANK('Table'[Full Notes],TRUE()),ALLEXCEPT('Table','Table'[Team Name]))
return IF(MAX('Table'[Full Notes])=_first , [Measure],BLANK())

If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @deefunk1981 ,

I have created a data sample for test:

Values in Matrix visual must be an aggregate value. Since your Full Notes column is Text type, it will automatically use First or Last or Count .

So I'd suggest you use CONCATENATEX() to combine values:

Combined Values = CONCATENATEX('Table',[Full Notes]," , ") 

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[deefunk1981]

Thank you so much Eyelyn, that worked!  However, I now have an issue with the data.  Each job has many rows which detail every step completed in the job.  So for example, one job might have 20 rows therefore my table now shows 20 concatenated "Full Notes" for each job.  Do you know how I could adjust my measure so that only 1 concatenated "Full Notes" appears for each job?

Thanks,

David