Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
18 | |
14 | |
14 |