Forum Discussion

Nsam1027's avatar
Nsam1027
Frequent Visitor
2 years ago
Solved

Matrix visual

In power Bi, In Matrix visual I need to show The column headers A, B, C, D (values present in column "F") and the rows will display the count of unique employee IDs and sum of FTE for distinct emplo...
General Comment
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Drag column B to the column well of the matrix visual.  Write these measures

    Measure 1 = countrows(Data)

    Measure 2 = sum(Data[Amount])

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Share some data and show the expected result.

  • Nsam1027's avatar
    Nsam1027
    Frequent Visitor
    2 years ago

    Hi Ashish, please find the screenshots below.Let me know if you need further details..fyi- I have already created a new table with unique Emp Id with FTE and Frequency.But not able to visualize as shown in the required visual.

     

     

    • Nsam1027's avatar
      Nsam1027
      Frequent Visitor
      2 years ago

      Sorry corrected required visual:

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        Hi,

        Drag column B to the column well of the matrix visual.  Write these measures

        Measure 1 = countrows(Data)

        Measure 2 = sum(Data[Amount])

        Hope this helps.