Final answer:
The function used to filter out totals from target figures is CALCULATETABLE, a DAX function used in Power BI, Analysis Services, and Power Pivot in Excel. It evaluates a table expression with applied filters to exclude totals.
Step-by-step explanation:
To filter out totals from target figures, you would most likely use the CALCULATETABLE function. This function is part of Data Analysis Expressions (DAX), which is a formula language used in Power BI, Analysis Services, and Power Pivot in Excel. CALCULATETABLE evaluates a table expression in a context that is modified by the given filters. While the Table.Filter and Table.SelectRows functions sound like they could be relevant, they are not actual DAX functions and seem more akin to M language functions used in Power Query for row operations. Table.FilterRows is also part of the M language and is used to filter rows in a table. However, when specifically working with DAX to filter out totals from figures, CALCULATETABLE would typically be the correct choice because it allows you to specify filters to apply to a table expression, which can be used to exclude totals.
Learn more about CALCULATETABLE