Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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).
// 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).
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.
Thank you in anticipation.
@Anonymous
Yes, you are right. I am looking for interval based on means. Formula I want to use is Confidence.T().
@AsadChanna14 - What is your calculation for confidence interval?
95%. Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |