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 employee IDs under each column header. How do I achieve this? 

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.

10 Replies

    • 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.