Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative measure error

Hi, I tried to follow this link to create a Cumulative measure but it doesn't work. When I pull the cumulative measure to the table, it stated "Can't display the visual". How to modify the measure so that I can view the cumulative measure for each member by product?

Here is the sample data.

 

BINOM.DIST.CUMULATIVE = 
SUMX( ADDCOLUMNS( GENERATESERIES(0,[No. of successes]), // For range, change 0 and [x] to the range 
"B",DIVIDE(FACT([No. of trials]),FACT([No. of trials] - [Value])*FACT( [Value])) * POWER([Probability of success], [Value]) * POWER(1-[Probability of success],[No. of trials]- [Value]) ),
 [B] ) 
 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    Can you try this

    BINOM.DIST.CUMULATIVE = 
SUMX( 
  ADDCOLUMNS( 
    GENERATESERIES(0,[No. of successes]), // For range, change 0 and [x] to the range 
    "B",DIVIDE(FACTORIAL([No. of trials]),FACTORIAL([No. of trials] - [Value])*FACTORIAL([Value])) * POWER([Probability of success], [Value]) * POWER(1-[Probability of success],[No. of trials]- [Value]) 
  ),
  [B] 
)


    Regards

    Dax_Noob

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous , "FACTORIAL" doesn't work. Thanks.