Power BI CalculateTable DAX function to create new virtual table and measure based on condition

Power BI Calculate Table DAX function tutorial on how to use calculatetable function to create new table or new measure based on condition or criteria.

Many times we have to create new table or aggregated measure from existing table by applying some criteria and power bi calculate table function can be handy in creating this.

[kartikeyatiwari]

very informative, thank you so much, ,, best part is it is simple

[caroliner.]

Hello there,
Thank you for this insight!
Is it possible, though, to filter the table dynamically: I mean, based on the result of a dax formula --> filter('table', 'table'[year]=[result of a dax formula]))?