Change denominator based on store

[Henrique_Quint]

Hey guys, how's it going?
I have a measure that divides amount of sales by salesperson allocated on each store. for example: 380 sales and 1200 salesperson on store 1.
The thing is, when I use this bar chart, it's dividing 380 by all salesperson on all stores, how do I fix this?

Just to be clear, sales is a measure that is CALCULATE(DISTINCTCOUNT()) and a lot of filters
Salesperson is also a CALCULATE(DISTINCTCOUNT()) with fewer filters

[samratpbi]

Hi,
without looking into your data and measures, its difficult to understand whats going wrong. However as you have mentioned in the measure you have some filters, and you are getting all Salesperson, then something in that measure removing filter context for store which is working fine for Sales. Please check any ALL function used in calculating total Salesperson or not.

Thanks!

[Henrique_Quint]

Hey! Sorry for that, here are my measures
Sales Measure:

Salesperson measure:

One Column of Sales table (ATIVIDADE FERRAMENT), Ano is year and MeioCaptacao is where a sales was made (on App or website)

Two columns on salesperson tablet (PENMM_DADOS) hat make the demoninator measure, Mind you that Revend/Ciclo column is not the same as the one of the sales table.

Here are the relations between them, this 2Dimensão_VD is a third table that connect visuals between other stuff

Hope that now you can help me, cheers 😃