Forum Discussion

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago
Solved

Customer Performance Status M.O.M

Hi All, I’ve created the below relationship, and I want to extract performance from the table Bounce and DPD to my master data (ECGLS), both have customer identification no as Account Number.   ...
  • AnkitKukreja's avatar
    AnkitKukreja
    5 years ago

    Hi All,

     

    I used the below measure, though i'm getting the correct results.

    Would love to know any another way to achieve the same. If possible from all the experts here.

     

    CALCULATE( SELECTEDVALUE( Bounce[BounceStatus] , “Not Presented” ) ,
    CROSSFILTER( ECGLS[Account Number] , Bounce[Account_Number] , Both),
    USERELATIONSHIP( ‘Calendar’[Date] , Bounce[schdate] ))

     

    Thanks,
    Ankit

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

Hey amitchandak 

 

Thanks for your response. Yes it is month on month. But, this is not what i want to achieve. 
May be I missed highlighting my point clearly, here by performance here i meant the payment history, whether it is paid or not paid.

 

So, I want to show status of payment on m.o.m basis against lan, industry, branch or any other variable. Example ( July- Bounce, Aug- Cleared, Sep- Cleared) . This is just an example.

 

Can you please look at my file once you've time.

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
5 years ago

Hi All,

 

I used the below measure, though i'm getting the correct results.

Would love to know any another way to achieve the same. If possible from all the experts here.

 

CALCULATE( SELECTEDVALUE( Bounce[BounceStatus] , “Not Presented” ) ,
CROSSFILTER( ECGLS[Account Number] , Bounce[Account_Number] , Both),
USERELATIONSHIP( ‘Calendar’[Date] , Bounce[schdate] ))

 

Thanks,
Ankit