Values of account with Hierarchies on matrix

Power Query
1

I’m having some troubling on displaying a matrix with my account values with hierarchies.
I believe i’ve done the right steps, i mean, first in power query we have to create the levels hierarchy,as many as the max lengh of the account. And on the visuals, i have to create 3 measures, to sum all credits, debits or liquid values but all with ISINSCOPE and ISBLANK.

  1. I don’t know if that measure has to have as many INSCOPE and ISBLANK lines as many hierarchies levels i need in the report.

  2. Some account doesn’t show the values of the sub levels, like in this example, where you can see on the left “12 - Depósitos à ordem” with a minus sign on the left. And on the right, you can see there’s 3 movements that should be there.

Capture11
Capture111111×114 21.9 KB

I’m attaching the power bi file. The table is Tab Movimentos (ml) which is connected with SNC, the account table.

I really hope that you can help me.
Thanks in advance
Best regards
Pedro

2

Hi guys
Problem solved with DAX.

Lvl02 =
LOOKUPVALUE (
‘Tab SNC’[Conta e Descrição],
‘Tab SNC’[Conta], PATHITEM ( ‘Tab SNC’[Path], 2, 0 )
)
Now i have to copy this to as many columns levels i have. The same in power it doens’t work or don’t know how.

Stay safe all of you
Pedro

1 Like