Forum Discussion

Vemul's avatar
Vemul
Icon for Helper I rankHelper I
1 year ago
Solved

Matrix data presentation for different groups

Hello Guru's    I am new to power Bi and truing to work on Matric display.    I have data for differnt groups with differnt types, I need to present data in Matrix table on individual section.  i...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Vemul 

    You can use a matrix visual with an impicit measure

    or an explicit one that sums the count column

    Sum of Count =
SUM ( 'Table'[Count] )

    This aside, your expected result doesnt match  your sample data. 995B should be 45 and not 38

Ray_Minds's avatar
Ray_Minds
Icon for Solution Supplier rankSolution Supplier
1 year ago

Hi  Vemul 

Create a Measure on the Count Column

Go to the Modeling tab in Power BI and create a new measure using the formula below:

Total Count = SUM(Table[Count])

This measure will calculate the total count for each combination of Group and Type.

  • Select the Matrix visual and add it to your report canvas.
  • Drag and drop the Group column, then the Type column under the Rows section and, Drag and drop the measure Total Count into the Values section.