Measure calculating average of groups based on another column

[Anonymous]

Hi All,

I have two columns (Store and State) and a measure Store-Value.  I need to calculate a measure State-Value (Average of Store-Value in a given state). 

In my report I have both store and state as a filter. I want to make sure when I select  stores in a state, state-value  still shows the average vaule of that state. For example: when I filter store A, State-value should still show 20 and not 10.

Thanks!

[Anonymous · Accepted solution]

Try something like
Calculate(divide(measure,count(table[state])),allexcept(table,table[state]))

If it didn't worked try all function.



Thanks
Pravin Wattamwar

If it resolves your problem mark it as a solution and give Kudos.

[Anonymous]

@Anonymous  Thanks for your solution. 

Calculate(divide(measure,count(table[state])),allexcept(table,table[state]))  works for me. 

[Anonymous]

Try allselected as well..

N please share your issue screenshot. So that it will be easy to understand your issue.