Evaluation contexts Measures Measures Blank FILTER Function ALL
Sign up to view full document!
SIGN UP
Evaluation contexts
Таблица Measures [ Measures] = {Blank()}
FILTER Function
ALL Function SUMX w ALL: =SUMX(ALL(Calc_Table), Calc_Table[Qty_On_Hand] * Calc_Table[Cost])
ALL Function SUMX_ALL = SUMX(Calc_Table, Calc_Table[Qty_On_Hand] * Calc_Table[Cost]) / sumx(ALL(Calc_Table), Calc_Table[Qty_On_Hand] * Calc_Table[Cost])
Removing Type filter = [AVR_Cost](ALL(Calc_Table[Type]))
- Slides: 23