cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

## 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!

2 ACCEPTED SOLUTIONS
Super User

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:

Super User

@Ramon_CN

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
8 REPLIES 8
Super User

@Ramon_CN

Use this meaure:

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Regular Visitor

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.

Super User

@Ramon_CN

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Regular Visitor

Fantastic Fowmy.

Thanks a lot for your concern.

Super User

i think that is a typo, this shall work:

measure = TRUE in VALUES(data[PX])
Regular Visitor

Super User

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:

Regular Visitor

Thanks a lot. Example file helped  much.

Code worked fine.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors