How to Create a New Table in Power BI from Existing Table Based on Filter Conditions

Power BI tutorial for beginners on how to create a new table from an existing table for a specific dimension and based on one or multiple filter conditions either on dimension or measure. This way you can create a new table from an existing table based on any condition you have in mind for your specific scenario using the DAX function calculatetable.

[jazmyncalvin]

Hi, how can you filter by multiple criteria from the same column? Say I wanted to filter by East & West.

[brunozaratecasallo]

Tanks. One question. How I manage to see this new table into power query? Because I will need it to merge with another table...

[pierre-antoinehebert]

Thanks for this example. is it possible to apply filter to this new table by using a segment value choosed in the report?

[salvinabraganza]

Hi, I created a new table using this formula but it gave me only the headers and no data. Plus no error was detected
How can I resolve this issue?

[avinashtirlotkar]

Did all transform steps applied on this new table also