Forum Discussion
Fragan
Helper III
6 years agoRow 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...
- 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
Helper III
6 years agoGreg_Deckler should i include this to my mesure or make a new one ??
Greg_Deckler
Community Champion
6 years agoI personally generally make a second measure. Helps with troubleshooting.