Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

hi

I have new Table 

 

Promotion Status =
SUMMARIZE(
    'bm_retail_t sale',
    'bm_retail_t sale'[DISC_TYPE]
)
 

Please help me to find errors in this measure. I got only    "Loss or Found" in return

 

SWITCH (
    TRUE (),
   
    [Count of Days CC (Sum Measure)]<= PERCENTILE.INC ( 'RFM Promotion Table'[D Promotion #days value], 0.10 ) &&
    [Invoice DISTINCTCOUNT Promotion (Summary)]<= PERCENTILE.INC ( 'RFM Promotion Table'[I Promotion #invoice value], 0.10 ) &&
    [Customer Count (Ssummary)]  <= PERCENTILE.INC ( 'RFM Promotion Table'[C Promotion #Customer value], 0.10 ) &&
    [M Promotion value (sale)]<= PERCENTILE.INC ( 'RFM Promotion Table'[Q Promotion Quantity value], 0.10 ) &&
    [Count Disc_type] <= PERCENTILE.INC ( 'RFM Promotion Table'[PU Promotion #Promotion_used value], 0.10 ),
"Poor Items, Below 10% ",


    [Count of Days CC (Sum Measure)]<= PERCENTILE.INC ( 'RFM Promotion Table'[D Promotion #days value], 0.20 ) &&
    [Invoice DISTINCTCOUNT Promotion (Summary)]<= PERCENTILE.INC ( 'RFM Promotion Table'[I Promotion #invoice value], 0.20 ) &&
    [Customer Count (Ssummary)]  <= PERCENTILE.INC ( 'RFM Promotion Table'[C Promotion #Customer value], 0.20 ) &&
    [M Promotion value (sale)]<= PERCENTILE.INC ( 'RFM Promotion Table'[Q Promotion Quantity value], 0.20 ) &&
    [Count Disc_type] <= PERCENTILE.INC ( 'RFM Promotion Table'[PU Promotion #Promotion_used value], 0.20 ),
"Good Items, Below 20%",
 
    "Loss or Found"
 
)
 
 please help
 
thanks
Need Help

1 Reply