Forum Discussion
Need a help with DAX (confidence Interval) -New USER
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 |
// 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).
6 Replies
- Greg_Deckler
Community Champion
Anonymous - What is your calculation for confidence interval?
- 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.
// 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).
