Total by 3 categories

[Anonymous]

Hi, i have a test table:

ID Nrb	Country	Scenario	Share
363331	Australia	Actual	1.00
363331	China	Actual	1.00
363331	Denmark	Actual	1.00
363331	Indonesia	Actual	1.00
363331	India	Actual	1.00
363331	Japan	Actual	1.00
363331	Canada	Actual	1.00
363331	Finland	Actual	1.00
363331	Norway	Actual	1.00
363331	Singapore	Actual	1.00
363331	Germany	Actual	1.00
363331	Spain	Actual	1.00
Total			1.00

I want to have a total share group by those 3 colums like 12

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can try to use the following measure formulas, I add a variable with summarize function to aggregate value based on categories and use the iterator function to apply these second aggregations to summary previous results.

formula =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Table ),
        [ID Nrb],
        [Country],
        [Scenario],
        "_Share", [Share]
    )
RETURN
    SUMX ( summary, [_Share] )

Regards,

Xiaoxin Sheng

[ryan_mayu]

@Anonymous 

is share column a measure?

if not, when you set share as sum, you should get 12

[Anonymous]

Hi, I forgett mention that Share is a measure

[ryan_mayu]

@Anonymous 

maybe you can try this

measure = sumx('Table',[share])