Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
2 years ago
Solved

want to see within GOALIMIT ROW

Hello to All, Only want to see one row per LEMNUM - within GOALIMIT when LEMNUM is same- color in BLUE As example LEMNUM 322185 - LINE_COST 279,000>250,000 and 279,000<=500,000 so PERSONID- MATTHE...
  • Fowmy's avatar
    Fowmy
    2 years ago

    ABC11 
    There are multiples ways. You can create a new table that filters only the final approvers.
    under modling tab, create a new table as follows:

    New Table = FILTER( Table03 , Table03[PERSONID] = Table03[APPROVER] )

    Result:

     




  • ABC11's avatar
    ABC11
    2 years ago

    Thanks lots for your time

  • Fowmy's avatar
    Fowmy
    2 years ago

    ABC11 

    Here are the modified codes:

    Calculated Column:

    APPROVER = 
    VAR __LemnumFiltered =  FILTER( Table03 , Table03[LEMNUM] = EARLIER(Table03[LEMNUM]) && Table03[ GOALIMIT ] > Table03[ LINE_COST ] )
    VAR __ApproverAmount = MINX( __LemnumFiltered , Table03[ GOALIMIT ] )
    VAR __Result = CONCATENATEX(  FILTER( __LemnumFiltered , Table03[ GOALIMIT ] = __ApproverAmount ) , Table03[PERSONID],"|" )
    RETURN
        __Result


    New Table:

    New Table = FILTER( Table03 ,  CONTAINSSTRING( Table03[APPROVER], Table03[PERSONID] ) )