Forum Discussion

sachingupta31's avatar
sachingupta31
New Member
2 years ago
Solved

Grouping multiple rows in 1 based on one column value in Power BI

Hello,   I have below data in power BI. URL Count /XXX/v1/sac 5 /XXX/v1/sac/ 10   What I would like to do is group the URL column value after cleaning them and then the final outp...
"DAX"
@Power BI
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi sachingupta31 ，

    Below is my table:

    The following DAX might work for you:

    Measure = 
   CALCULATE(
      SUM('Table'[col2]),
      ALLEXCEPT('Table','Table'[col 1])
   )

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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

Rupak_bi's avatar
Rupak_bi
Icon for Super User rankSuper User
2 years ago

if the Url exactly matches, it should work. please share sample data to check.

sachingupta31's avatar
sachingupta31
New Member
2 years ago

Hi Rupak_bi  PFA, sample data and output.  Also, col1 is a column in a table and Col2 is measure created using below formula.
col2 Measure formula= CALCULATE(COUNT(Related Features))

please let me know if it works.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sachingupta31 ，

    Below is my table:

    The following DAX might work for you:

    Measure = 
   CALCULATE(
      SUM('Table'[col2]),
      ALLEXCEPT('Table','Table'[col 1])
   )

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

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