image-2

Power BI: CALCULATETABLE function DAX

CALCULATETABLE function is a power bi filter function in DAX that evaluates a table expression in a context modified by the given filters. It returns a table of values. CALCULATETABLE(<expression>,<filter1>,<filter2>,…) <expression> is a table expression to be evaluated. A measure can not be used as expression. <filter1>,<filter2>.. is a Boolean expression or a table expression Read More