Forum Discussion

Fragan's avatar
Fragan
Helper III
6 years ago
Solved

Row Sub Total equals is calculated

Hey,   I have this table :   And i want to calculate foreach day and foreach group 1and2 % wich is (Attribute1/Attribute2)*100 And i want to include `1and2 %` in Group Subtotal and on tota...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    OK, taking a look back at the original post, perhaps something like:

     

    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])
  )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

OK, taking a look back at the original post, perhaps something like:

 

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])
  )
Fragan's avatar
Fragan
Helper III
6 years ago

Greg_Deckler Dude you're straight fire lmao. It works, i'll read the docs in order to understand how this works.

 

Thanks again