Forum Discussion

ilTac's avatar
ilTac
Frequent Visitor
5 years ago
Solved

Need Help With Matrix

Hi everyone, i'm fearly new with Power Bi and i would like your help with this issue. My database looks like this:   and i would like a rapresentation that shows for each sector the activit...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ilTac ,

    Please update the formula of measure as below and check whether it can get your desired result:

    Measure =CALCULATE( CONCATENATEX ( DISTINCT ( 'Table'[Activities] ), 'Table'[Activities], "," ))

    or

    Measure =CALCULATE( CONCATENATEX ( VALUES( 'Table'[Activities] ), 'Table'[Activities], "," ))

    If the above one is not applicable for your scenario, please provide the requirement with sample data and your expected result. Thank you.

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

amitchandak's avatar
amitchandak
Super User
5 years ago

ilTac , Can concatenation is an option?

Try measure like

concatenatex(Table, Table[activities])


concatenatex(Table, Table[activities],",")

  • ilTac's avatar
    ilTac
    Frequent Visitor
    5 years ago

    amitchandak Hi, thaks for the answer but i didn't understand well. I have to try to create a new measure in the query using those sintax?

    Thank you

     

    EDIT: the solution works! The only problem is that sometimes Activities has color code so if there are two activities in the same week with concatenatex that two activities are in the same cell and have only one color. Do you know some work around to this?

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi ilTac ,

      Please update the formula of measure as below and check whether it can get your desired result:

      Measure =CALCULATE( CONCATENATEX ( DISTINCT ( 'Table'[Activities] ), 'Table'[Activities], "," ))

      or

      Measure =CALCULATE( CONCATENATEX ( VALUES( 'Table'[Activities] ), 'Table'[Activities], "," ))

      If the above one is not applicable for your scenario, please provide the requirement with sample data and your expected result. Thank you.

      Best Regards
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.