Binomial Distribution Cumulative error measure

[PBI_newuser]

Hi, I tried to follow this link to create a measure for Binomial Distribution Cumulative but it doesn't work. When I pull the "BINOM.DIST.CUMULATIVE" field to the table, it stated "Can't display the visual". How to modify the measure so that I can view the Binomial probability 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] )

[v-jialluo-msft]

Hi  @PBI_newuser ,

Please follow these steps:
(1) Create a new measure

BINOM.DIST = 

var _a=IF([Probability of success]=0&&[No. of successes]=0,0,POWER([Probability of success],[No. of successes]))

var _b=IF(1-[Probability of success]=0&&[No. of trials]-[No. of successes]=0,0,POWER(1-[Probability of success],[No. of trials]-[No. of successes]))

var _c=

IF(ISINSCOPE('Table'[Member]),

DIVIDE(FACT([No. of trials]),

FACT([No. of trials] - [No. of successes])*FACT([No. of successes])) * _a * _b)

return _c

(2)Final output

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PBI_newuser]

Hi @v-jialluo-msft , thank you for your help. Could you please help on "BINOM.DIST.CUMULATIVE" measure too? I need the cumulative measure to do some calculation. Below is the one I created but with error message.

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