true-false
1 Topic
Goup by and count occurences meassure
Hi everybody. I'm new on the board. I have this Table (VendesAnnex), Order Num Line Num PX 1418 1 True 1418 2 True 1418 3 False 1419 1 True 1419 2 True 1420 1 False 1420 2 False 1421 1 True 1421 2 False 1422 1 False 1422 2 False 1422 3 False 1422 4 False And need a meassure that returns True/False after grouping (Vendes Annex) by [Order Num] where True means at least 1 [Line num] = "True" and False means that none [Line Num] ="True": Expected Resul would be: Order Num PX 1418 True 1419 True 1420 False 1421 True 1422 False If it is in two steps/Meassures is not a problem. I' ve tried different ways and the ouput I get is a filtered table where all values are "True". Thanks Folks!Solved1.9KViews0likes8Comments