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 another chart or table visual

in pbi i have given the infor more as well

Please correct my pbi and help me to do

thanks

RFM Sample.pbix302 KB

Need Help

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
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

5 Replies

abc_777
Solution Specialist
2 years ago
Hello

can some one help me for that issue i have atttached. need help

thanks
- abc_777
  Solution Specialist
  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
Solution Specialist
2 years ago
Ashish_Mathur ,

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

thx
- 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
    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

Forum Discussion

hi