Forum Discussion

deefunk1981's avatar
deefunk1981
Frequent Visitor
4 years ago
Solved

Matrix Values (show all)

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 concatena...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

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's avatar
    deefunk1981
    Frequent Visitor
    4 years ago

    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