Forum Discussion

tc_WII's avatar
tc_WII
Frequent Visitor
3 years ago
Solved

USERELATIONSHIP Issue

Hello, I have 2 tables. ID Table: ID Price Parent A 25   B 29 A C 30 A D 41   E 42 D F 43 D   shippingTable: ID Shipping A 3 D 5   For B...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tc_WII ,

     

    I suggest you to try code as below to create a measure.

    shipCost =
VAR _VALUE1 =
    CALCULATE ( MAX ( tbShipping[Shipping] ) )
RETURN
    IF (
        ISBLANK ( _VALUE1 ),
        CALCULATE (
            MAX ( tbShipping[Shipping] ),
            FILTER ( ALL ( tbShipping ), tbShipping[ID] = MAX ( tbID[Parent] ) )
        ),
        _VALUE1
    )

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tc_WII's avatar
tc_WII
Frequent Visitor
3 years ago

I used the same measure, but it did not work in my model. The only difference on your data model is, both of your relationship is one-to-many. but i used id-id as one to one, only because tbID[ID] is also unique value. Because of that one-to-one, my measure is not grabbing the result 😞

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tc_WII ,

 

I suggest you to try code as below to create a measure.

shipCost =
VAR _VALUE1 =
    CALCULATE ( MAX ( tbShipping[Shipping] ) )
RETURN
    IF (
        ISBLANK ( _VALUE1 ),
        CALCULATE (
            MAX ( tbShipping[Shipping] ),
            FILTER ( ALL ( tbShipping ), tbShipping[ID] = MAX ( tbID[Parent] ) )
        ),
        _VALUE1
    )

Result is as below.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • tc_WII's avatar
    tc_WII
    Frequent Visitor
    3 years ago

    This worked. Thank you 🙂