Cumulative measure error

[PBI_newuser]

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

[Anonymous]

Hi @PBI_newuser 

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

[PBI_newuser]

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