Ignoring some filters on visual/ measure? but not all? simple dividing?

[Cody99]

Im struggeling with a little problem.
I want to get all customers data YTD in a mesure like this:

Total customers (ignore filters) = CALCULATE(COUNTROWS('3117 report Mail'), ALL('3117 report Mail'), '3117 report Mail'[xx / xx] = "xx")
And then i have a measure that divide "spenders" with "total customers" in this measure

Active customer Intake = 'Sales YTD Intake'[Spenders intake]/'3117 report Mail'[Total customers (ignore filters)]

But then every row of sales people, gets its "spenders", devided in "total customers" and not its own customers.

It should be the salespersons own spenders devided in its own customers.
But since i remove filter on the first mesure, i guess it cant find the sales person either?

So on this visual every row gets "spenders" divided in to "all customers", and its own customers.
Any suggestions?

[Anonymous]

Hi @Cody99,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Cody99]

I really dont know how i could do that?
I have tried to explain as good as i can. And i think its kinda explains it for professionals as you guys? 🙂
Is there a part of my explaination that i can explain better?

[Anonymous]

HI @Cody99,

Normally you can use all functions in measure expression to exclude the filter effects to calculate without external filter effects.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

In addition you can try to extract the correspond condition values from other table fields and manually use these in calculation instead of directly use table relationships.

Regards,

Xiaoxin Sheng

[Cody99]

Thanks, ill try this, ill get back with my findings 🙂