Forum Discussion

Vemul's avatar
Vemul
Helper 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

MasonMA's avatar
MasonMA
Super User
1 year ago

Vemul 

I'd suggest you keep using Matrix table even though it does not render exactly the same format as in your second picture. 

I'd also recommend using Outline for Layout, disabling '+/- icon' under Row Header and only showing Subtotal for Row level 'Type'.