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.
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!
Solved! Go to 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
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] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Ramon_CN
Use this meaure:
Num pX = TRUE() IN VALUES( TableName[PX] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
@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] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Fantastic Fowmy.
Your meassure works great now!
Thanks a lot for your concern.
i think that is a typo, this shall work:
Thanks for your help FreemanZ.
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:
Thanks a lot. Example file helped much.
Code worked fine.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |