Goup by and count occurences meassure

[Ramon_CN]

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!

[FreemanZ · Accepted solution]

hi @Ramon_CN ,

try to plot a table visual with Order Number and a measure like:

OrderPX = 
IF(
    TRUE in VALUES(data[PX]),
    TRUE, FALSE
)

it worked like:

[Fowmy]

@Ramon_CN 

Use this meaure:

Num pX = TRUE() IN VALUES( TableName[PX] )

[Ramon_CN]

Thanks Fowmy for your help.

Your code seems very elegant, And it may work but not to me. 

I tried it in a plane orders Visual table, and it colapsed.

Message Error on CONTAINSROW does not allow comparing values text type with True/False Type. 

Thanks anyway. 

[Fowmy · Accepted solution]

@Ramon_CN 

Glad you had your problem resolved.

I made the DAX calculation assuming you had logical values as TRUE and FALSE but it is text, that's the reason you faced this issue. As pointed out by @FreemanZ , you can modify my measure as follows and it should work. 

Num pX = TRUE IN VALUES( TableName[PX] )

[Ramon_CN]

Fantastic Fowmy.

Your meassure works great now!

Thanks a lot for your concern. 

[FreemanZ]

i think that is a typo, this shall work:

measure = TRUE in VALUES(data[PX])

[Ramon_CN]

Thanks for your help FreemanZ. 

[FreemanZ · Accepted solution]

hi @Ramon_CN ,

try to plot a table visual with Order Number and a measure like:

OrderPX = 
IF(
    TRUE in VALUES(data[PX]),
    TRUE, FALSE
)

it worked like:

[Ramon_CN]

Thanks a lot. Example file helped  much.

Code worked fine.