How to build a measure that select all except the selected slicer dimension?

[ahassan44]

Hey, 

I have a staff location table, and a transaction location table, and I want build a measure that calculate revenue that addsall transaction locations except the selected staff location.

Is there a way to accomplish that without adding a new column since I can only add measures to my model?   

Thanks!

[v-yetao1-msft]

Hi @ahassan44 

Can you provide a detail sample to show your data ? We have no way of providing specific formulas without knowing your data .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ahassan44 , Assume you want to count or sum from the transaction table

then

calculate(countrows(transaction ), filter(transaction , not transaction[Location] in values(Staff[Location]) ) )