Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Binomial Distribution Cumulative error measure

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

 

 

Need Help

2 Replies

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Community Support
    3 years ago

    Hi  Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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