User Profile
Cody99
Helper II
Joined 3 years ago
User Widgets
Contributions
Ignoring some filters on visual/ measure? but not all? simple dividing?
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?
