Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
17 |