Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
2 years ago
Solved

Using a Measure as a Row Header

Hello,   I have a table that shows the Sales by the Employee, Country and City. I need to show a matrix visual as a report that breaks down the Sales by Employee and all the cities they had sales i...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi newpbiuser01 ,

    Based on my testing, please try the following methods as workaround:

    1.Create the sample table.

    2.Create the new measure to calculate the sales, quantity and cities.

    Sum of Sales = if(ISINSCOPE('Table'[Team])&&ISINSCOPE('Table'[Employee]),SUM('Table'[Sales]))
    Sum of Quantity = if(ISINSCOPE('Table'[Team])&&ISINSCOPE('Table'[Employee]),SUM('Table'[Quantity]))
    Cities = if(ISINSCOPE('Table'[Employee])&&ISINSCOPE('Table'[Team]),BLANK(),CONCATENATEX(VALUES('Table'[City]), 'Table'[City], ", "))

    3.Drag the measures into the matrix values.

    4.Set the warp in the format settings.

    5.Drag the left border to override the measure.

    6.The result is shown below.

    Besides, you can also raise a new idea and add the comments there to make the feature coming sooner.

    Home (microsoft.com)

     

    Best Regards,

    Wisdom Wu

    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
2 years ago

Hi newpbiuser01 ,

Based on my testing, please try the following methods as workaround:

1.Create the sample table.

2.Create the new measure to calculate the sales, quantity and cities.

Sum of Sales = if(ISINSCOPE('Table'[Team])&&ISINSCOPE('Table'[Employee]),SUM('Table'[Sales]))
Sum of Quantity = if(ISINSCOPE('Table'[Team])&&ISINSCOPE('Table'[Employee]),SUM('Table'[Quantity]))
Cities = if(ISINSCOPE('Table'[Employee])&&ISINSCOPE('Table'[Team]),BLANK(),CONCATENATEX(VALUES('Table'[City]), 'Table'[City], ", "))

3.Drag the measures into the matrix values.

4.Set the warp in the format settings.

5.Drag the left border to override the measure.

6.The result is shown below.

Besides, you can also raise a new idea and add the comments there to make the feature coming sooner.

Home (microsoft.com)

 

Best Regards,

Wisdom Wu

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