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 ,

 

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.