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

[Anonymous]

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

[Anonymous · Accepted solution]

// 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).

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

@Anonymous 

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

[Greg_Deckler]

@Anonymous - What is your calculation for confidence interval?

[Anonymous]

95%. Thanks