subtotal of column

[Shreesefwere]

converting text to values without using sum() or any other aggregation

11m ago

Hi Expert,

Have 2 columns in dimension which shows currently in dimension as we did not sum it but wanted to see the subtotal for the same in mdx query

i.e.

col1 col2  required column in should show same values without doing sum but should show the sumtotal and max mean

a       40  40

b       60  60

Total        100

[Shreesefwere]

suggestion please

[v-rzhou-msft]

Hi @Shreesefwere ,

I think you want to sum the max col2 per col1 in subtotal.

My Sample:

You can try this code to create a measure.

Sum of Max col2 = 
SUMX(SUMMARIZE('Table','Table'[col1],"Max col2",MAX('Table'[col2])),[Max col2])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shreesefwere]

i just want subtotal of the col2 without changing the values on row level

for an example : a comes forr 3 times and so it should not sum but only show subtotal

a 10

a 10

a 30

T 40

[v-rzhou-msft]

Hi @Shreesefwere ,

I think you can try this code to create a measure.

Subtotal = 
SUMX(DISTINCT('Table'[Col2]),[Col2])

My Sample:

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shreesefwere]

suggestion please

[Shreesefwere]

suggestion pls