Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

I have attached a sample pbi file for RMF and RCM Analsys   I want to use one RFM table where i want to filter RFM segment by customer_code in one chart or table visual and by mobile_no in anothe...
Need Help
  • abc_777's avatar
    abc_777
    2 years ago

    Hi,

     

    can some one tell me if its not possible to do. with customer_code and same time with mobile_no

     

    if can pissble please help me

     

    thanks

  • abc_777's avatar
    abc_777
    2 years ago

    Ashish_Mathur 

     

    thanks for your reply

     

    I have raised this issue more than a week but no one helped me.

     

    If you see the attached pbi sample file you will see i create one RFM table where i want to do

    1) RFM analysys for recency, frequency and monetory

    and another one

    2) RCM analysys for recency, cell no or mobile no and monetory

     

    I have another table for customer segmentation

     

    so i want to see RFM analysys by cusotmer_code and RCM analysys by cusomter Mobile_NO

    this is the senario

     

    if my understanding is totall incorrect please modify the sample file

     

    Please help me for doing this. if u not understand or still have gap please write. i will clearify that

     

    thanks Ashish, please help

abc_777's avatar
abc_777
Solution Specialist
2 years ago

Ashish_Mathur ,

 

hello ashish, would be able to solve the attached issue please

 

thx

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    I have read the content in the PBI file but just cannot understand your requirement.  I do not understand the reason for creating a calculated table and of creating a many to many relationship.

    Someone who understand your problem will help. 

    • abc_777's avatar
      abc_777
      Solution Specialist
      2 years ago

      Ashish_Mathur 

       

      thanks for your reply

       

      I have raised this issue more than a week but no one helped me.

       

      If you see the attached pbi sample file you will see i create one RFM table where i want to do

      1) RFM analysys for recency, frequency and monetory

      and another one

      2) RCM analysys for recency, cell no or mobile no and monetory

       

      I have another table for customer segmentation

       

      so i want to see RFM analysys by cusotmer_code and RCM analysys by cusomter Mobile_NO

      this is the senario

       

      if my understanding is totall incorrect please modify the sample file

       

      Please help me for doing this. if u not understand or still have gap please write. i will clearify that

       

      thanks Ashish, please help