cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Make rows <<NAME %>>a sub row of <<NAME>>

Hey,

I have this table

I made a mesure to calculate "Attribute1 %" wich is Attribute1/Attribute2*100, and to do this i created :

• A table :
`Table3 = UNION(DISTINCT('Table'[Attributes]);{{"1and2 %"}})`
• Mesure :
```Measure =
SUMX (
DISTINCT ( 'Table3'[Attributes] );
SWITCH (
'Table3'[Attributes];
"1and2 %"; IFERROR((CALCULATE ( SUM ( 'Table'[Value] ); 'Table'[Attributes] = "Attribute1" )
/ CALCULATE ( SUM ( 'Table'[Value] ); 'Table'[Attributes] = "Attribute2" ))*100;0);
var a = 'Table3'[Attributes] return
CALCULATE ( SUM ( 'Table'[Value] );'Table'[Attributes]=a)
)
)```
I also have a second mesure to exclude % from Subtotals and grand totals :
```Measure 2 =
VAR __Table =
SUMMARIZE(
'Table 3',
[Group],
[Attribute],
"__Measure",[Measure]
),
"__IncludeInTotals",SEARCH("%",[Attribute],,-1)
)
RETURN
IF(
HASONEVALUE('Table 3'[Attribute]),
[Measure],
SUMX(FILTER(__Table,[__IncludeInTotals] = -1),[__Measure])
)​```

So now my Table looks like this :

Now what i want to do is to make "Attribute1 %" a sub row of "Attribute1" (Like Attribute1, Attribute2 are sub rows of C1). And i want to do this for each Attribute. For example in the future i'll have "Attribute2 %", "Attribute3 %", etc and i want "AttributeX %" to be a sub row of "AttributeX".

Im really new to PowerBI so i'd really appreciate it if anyone can help me out with that.

Regards

1 ACCEPTED SOLUTION
Helper III

You sure that this can do the job ? I mean i think if i do that i wont be able to show Attribute1 value.

Given your suggestion i think this may work :

Group Attribute Attribute%
C1 Attribute1 Attribute1 %
C1 Attribute1

C1 Attribute2
C1 Attribute3

What do u think ?

2 REPLIES 2
Super User
You would need a setup like this:

Group Attribute Attribute%
C1 Attribute1 Attribute1 %
C1 Attribute2
C1 Attribute3
...

That would enable you to build the proper hierarchy.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper III

You sure that this can do the job ? I mean i think if i do that i wont be able to show Attribute1 value.

Given your suggestion i think this may work :

Group Attribute Attribute%
C1 Attribute1 Attribute1 %
C1 Attribute1

C1 Attribute2
C1 Attribute3

What do u think ?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.