topic Re: Help Needed in DAX Commands and Tips

Help Needed

Waqas_BIspecs — Thu, 07 Sep 2023 16:13:46 GMT

Hi,

In the below image you can see i have a pallet_id_from column where there are multiple instances appearing against these in if_tran_code column. i was to create another calculated column where i can mark all these instances against the Pallet-_id as "Shipped" if there there is one instance i.e. "FO-LOAD" exists against this column.

Note: This data is coming through Direct Query from SQL.

Required Output:

Thank you

Re: Help Needed

tamerj1 — Thu, 07 Sep 2023 17:29:54 GMT

Hi Waqas_BIspecs

Please try

Status =
IF (
"FO-LOAD"
IN CALCULATETABLE (
VALUES ( 'Table'[if_tran_code] ),
ALLEXCEPT ( 'Table', 'Table'[pallet_id_from] )
),
"Shipped"
)

Re: Help Needed

Waqas_BIspecs — Thu, 07 Sep 2023 18:16:14 GMT

Hi,

Its making everything "shipped"

Re: Help Needed

tamerj1 — Thu, 07 Sep 2023 20:15:15 GMT

Waqas_BIspecs

Yes you are right. The small sample of data was a little misleading. You need to add activity-date to ALLEXCEPT

Status =
IF (
"FO-LOAD"
IN CALCULATETABLE (
VALUES ( 'Table'[if_tran_code] ),
ALLEXCEPT ( 'Table', 'Table'[pallet_id_from], 'Table'[activity-date] )
),
"Shipped"
)