topic Re: Goup by and count occurences meassure in DAX Commands and Tips

Goup by and count occurences meassure

Ramon_CN — Sun, 17 Dec 2023 12:26:25 GMT

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!

Re: Goup by and count occurences meassure

FreemanZ — Sun, 17 Dec 2023 12:59:27 GMT

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:

Re: Goup by and count occurences meassure

Fowmy — Sun, 17 Dec 2023 13:15:48 GMT

Ramon_CN

Use this meaure:

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

Re: Goup by and count occurences meassure

Ramon_CN — Sun, 17 Dec 2023 17:01:26 GMT

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.

Re: Goup by and count occurences meassure

Ramon_CN — Sun, 17 Dec 2023 17:02:37 GMT

Thanks a lot. Example file helped much.

Code worked fine.

Re: Goup by and count occurences meassure

FreemanZ — Mon, 18 Dec 2023 00:53:24 GMT

i think that is a typo, this shall work:

measure = TRUE in VALUES(data[PX])

Re: Goup by and count occurences meassure

Fowmy — Mon, 18 Dec 2023 07:12:15 GMT

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] )

Re: Goup by and count occurences meassure

Ramon_CN — Mon, 18 Dec 2023 17:12:49 GMT

Fantastic Fowmy.

Your meassure works great now!

Thanks a lot for your concern.

Re: Goup by and count occurences meassure

Ramon_CN — Mon, 18 Dec 2023 17:14:04 GMT

Thanks for your help FreemanZ.