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

[Fragan]

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 =
    ADDCOLUMNS(
      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

[Greg_Deckler]

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.

[Fragan · Accepted solution]

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 ?