Create a calculated table filtering by a measure

In many ways...

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Refering a measure in calculated table easily leads to confusion, as in most cases there are row context, hidden CALCULATE and thus context transition.

it would be better to provide a scenario with sample data and your expected result.

Hi Anonymous ,

Calculated Tables are created at refresh time, while Measures are calculated at query time. After you create a calculated table, please establish a relationship between your fact tables and your calculated table, and then you can use a slicer to filter the new table.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your answers.

im going to be more specific. I have a table with columns of: Products, quantity sold, earnings. Also this table has geographical location, store where transaction was done, week, year etc...

In my pbi i have the following visual object: 

First two columns from my visual objects are not measures, others columns are all measures. In yellow a measure that takes values of 1 oe 0 depending of another measure. y want to use this yellow column to create a calculated table, showing the rows only when "yellow" is 1.

My visual object is filtered showing just one product. I would like to have a table similar to my visual object, adding column product. I want that because in my visual obj i have a lot of usefull operations using previus rows for example.

thanks, if you need more details tell me.