Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
How can i create a calculated table filtering this new table by a measure that i created?
Solved! Go to Solution.
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.
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.
I Solved using dax, ty everyone!
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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
22 | |
10 | |
10 | |
9 | |
7 |