Forum Discussion

acroberts's avatar
acroberts
Frequent Visitor
9 years ago
Solved

Matrix/Pivot Question

Hello, I am trying to create a Power BI Matrix from sales data that looks like:     To create a summary, by sales person, by count of their role in a sale:     I'm probably overth...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    acroberts

     

    Hi, in Edit Query Select the 3 columns (Except Opp ID) and Transform Unpivot Columns.

     

    You'll obtain something like this:

     

     

    Change the name of the Columns. Close & Apply

     

    Finally in a Matrix

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You aren't going to get away from building a separate person table.   Once you have done that you can probably write measures --

 

Total Id := DISTINCTCOUNT(MyTable[Identify])

Total Develop := DISTINCTCOUNT(MyTable[Develop])

...