Forum Discussion
Grouped norm dist
Hi all, I'm trying to make a grouped norm.dist calculation but can't yet figure it out. Below an example of my dataset (item, price): chair 30 couch 400 table 200 table 150 ...
Aha, Anonymous try to add three columns like:
mean2 = VAR _table = FILTER( TableName, TableName[item] = EARLIER(TableName[item]) ) RETURN AVERAGEX( _table, TableName[Price] ) med2 = VAR _table = FILTER( TableName, TableName[item] = EARLIER(TableName[item]) ) RETURN CONVERT( MEDIANX( _table, TableName[Price] ), INTEGER ) std.dev2 = VAR _table = FILTER( TableName, TableName[item] = EARLIER(TableName[item]) ) RETURN STDEVX.P( _table, TableName[Price] )it worked like:
FreemanZ
Super User
Super Userhi Anonymous
try to create a calculated table like:
Table =
ADDCOLUMNS(
VALUES(TableName[Product]),
"mean",
CALCULATE(MEAN(TableName[Price])),
"median",
CALCULATE(MEDIAN(TableName[Price]))
)
The problem is that it calculates everything on all the data, while you want to know the mean/median/stddev based on the items prices. Example;
| item | price | stddev |
| chair | 30 | A |
| couch | 400 | B |
| table | 200 | C |
| table | 150 | C |
| chair | 11 | A |
| desk | 100 | D |
| chair | 60 | A |
| couch | 180 | B |
| chair | 100 | A |