cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper II

## Total by 3 categories

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

1 ACCEPTED SOLUTION
Community Support

Hi @yellow_old_5,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
4 REPLIES 4
Community Support

Hi @yellow_old_5,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

is share column a measure?

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

Proud to be a Super User!

Helper II

Hi, I forgett mention that Share is a measure

Super User

maybe you can try this

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

Proud to be a Super User!