measure values change based on row selections

[aheavy95]

Hi all 
I am running into a weird problem.

In a table chart ,  there is an order column and a measure.

For order ID  7660163, when no orders are filtered, the measure equals 0  (it should be 1)

and once I filter this specific Order ID I get 1 in the measure- which is what I should get 

 same thing applies for more Order Id's 

this is the measure calculation in case it helps

Appreciate your help

[vinieme12 · Accepted solution]

Aggr by both OrderID and UserEmail at the moment it’s only aggregating by useremail

[aheavy95]

Thant helped thanks a lot