topic Re: Need a help with DAX (confidence Interval) -New USER in DAX Commands and Tips

Need a help with DAX (confidence Interval) -New USER

Anonymous — Thu, 23 Jul 2020 17:59:31 GMT

Hello, I am a new user of Dax. I need to calculate the confidence Interval based on ITEMSID in the table.

Also, Could you please suggest the best way to plot confidence Intervals based on items. Thanks!

AuctionId	BidderID	ItemsID	BID($)
A	1	123	5
A	2	123	15
A	2	780	9
A	3	780	10
B	4	992	15
B	3	992	20
B	5	100	30
B	6	100	32
B	6	889	20
D	7	155	30
D	8	155	35
D	6	110	30
D	9	110	32

Re: Need a help with DAX (confidence Interval) -New USER

Greg_Deckler — Thu, 23 Jul 2020 18:17:34 GMT

Anonymous - What is your calculation for confidence interval?

Re: Need a help with DAX (confidence Interval) -New USER

Anonymous — Thu, 23 Jul 2020 18:24:21 GMT

95%. Thanks

Re: Need a help with DAX (confidence Interval) -New USER

Anonymous — Fri, 24 Jul 2020 16:14:22 GMT

You have to tell which formula you want to use since there are different formulas for different things. I'd assume you want an interval - that is, the bounds - for the mean but even so, you have to say what assumptions you're making about the data.

Thanks.

Re: Need a help with DAX (confidence Interval) -New USER

Anonymous — Fri, 24 Jul 2020 16:24:39 GMT

Anonymous

Yes, you are right. I am looking for interval based on means. Formula I want to use is Confidence.T().

Re: Need a help with DAX (confidence Interval) -New USER

Anonymous — Fri, 24 Jul 2020 16:48:56 GMT

// hidden auxiliary measure [__95-Conf Delta] = var __sd = STDEV.S( T[BID($)] ) var __size = COUNTROWS( T ) var __alpha = 0.05 var __delta = CONFIDENCE.T( __alpha, __sd, __size ) return __delta [95-Conf Lower Bound] = var __mean = AVERAGE( T[BID($)] ) var __delta = [__95-Conf Delta] return __mean - __delta [95-Conf Upper Bound] = var __mean = AVERAGE( T[BID($)] ) var __delta = [__95-Conf Delta] return __mean + __delta // The above work for any slicing, // not only when you do by ITEMSID. // Now you can plot both measures // against anything in your table(s).

Re: Need a help with DAX (confidence Interval) -New USER

Anonymous — Sun, 26 Jul 2020 03:00:25 GMT

Hi, I am a new user of DAX. Could you please help me with the following problems.

I am trying to get Probability (Poison Distribution) based on the Item ID for a given range of values. For Example, itemID 123, there is 10% probability values fall between 10 to 15.

I used the following formula. But it is picking a range of values from 0 to Given value. Need something like a Poison Distribution Column.

ItemsID	BID($)	Poison Distribution Probability
123	5	10%
123	15	10%
780	9	15%
780	10	15%
992	15	10%
992	20	10%
100	30	3%
100	32	3%
889	20	1%
155	30	2%
155	35	2%
110	30	17%
110	32	17%

Currently, I am getting this with the following Measure formula.

Prob = POISSON.DIST(10;[MEAN2];TRUE)

Thank you in anticipation.