Calculating logical column from two different Logical tables

Question

Hello All,

I've a scenario where I've to create a logical column in logical fact which filters the records based on the column in the dimension.

For example, I want to get the Number of products whose status is Not delivered. Here Product ID is in Fact where as status column is in Dimension. So How can I calculate a metric for "Number of  Products which are 'Not Delivered'". Then I've to calculate one more logical column

'Percentage products not delivered".

PS: I tried writing the following expression while creating new logical column but unable to do it.

(Filter("EDW"."Fact"."Product ID"  when ("EDWBTI"."Status"."Status Description"  = 'Not Delivered' ) ) and I also tried

(Filter("EDW"."Fact"."Product Count"  when ("EDWBTI"."Status"."Status Description"  = 'Not Delivered' ) )

Thanks.

[Deleted User] · Answer

You need the dimension table as part of the fact LTS. Join it in and then you can do the calculation.

Because don't forget: post-aggregate calculations in derived calcs are quite different than actual pre-aggregate calcs.