topic Re: Create a calculated table filtering by a measure in DAX Commands and Tips

Create a calculated table filtering by a measure

Anonymous — Sat, 19 Nov 2022 11:03:20 GMT

Hi,

How can i create a calculated table filtering this new table by a measure that i created?

Re: Create a calculated table filtering by a measure

daXtreme — Sat, 19 Nov 2022 12:39:06 GMT

In many ways...

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

Re: Create a calculated table filtering by a measure

FreemanZ — Sat, 19 Nov 2022 15:01:10 GMT

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.

Re: Create a calculated table filtering by a measure

v-xiaosun-msft — Mon, 21 Nov 2022 08:06:38 GMT

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.

Re: Create a calculated table filtering by a measure

Anonymous — Mon, 21 Nov 2022 12:10:15 GMT

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.

Re: Create a calculated table filtering by a measure

Anonymous — Mon, 21 Nov 2022 12:15:49 GMT

The reaason why i want this is because i want to be able to calculate the function of a trend line that i get when i compare two measures that i have in my table. Maybe to do that is not necesary to all calculations again in a new calculated table?

Thanks everyone.

Re: Create a calculated table filtering by a measure

Anonymous — Mon, 21 Nov 2022 14:31:37 GMT

I Solved using dax, ty everyone!