Forum Discussion
Share based on total for specific value
Hello, I have the following matrix: I have a column in my table named "Exists" which has value "1" if a brand exists in a store. I want to calculte the Share for each store compared to the Count...
Hi Anonymous
Create measures
total exsits = SUM('Table'[exsits]) exsits in country = CALCULATE(SUM('Table'[exsits]),FILTER(ALLSELECTED('Table'),'Table'[market]="country")) % = [total exsits]/[exsits in country]Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Create measures
total exsits = SUM('Table'[exsits])
exsits in country = CALCULATE(SUM('Table'[exsits]),FILTER(ALLSELECTED('Table'),'Table'[market]="country"))
% = [total exsits]/[exsits in country]
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-juanli-msft ,
Thank you, it worked!
I have created a measure like this, but the total for country was not on each row. Maybe because I was not using allselected. I'm new to this calculations, I don't now exactly what to use and when.
But now it works, thank you!