Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Every month the number of animals fed per category is updated on this table
then I have this other table with fixed values that represent the total number of animals in the USA. These two tables are connected by "Categories". On the table above I want to have a column that represents the % of animas that the company feed based on the US Inventory for each category. How can I do that? I have tried calculate with divide function using sumx, etc... but no sucess. Suggestions please.
Solved! Go to Solution.
@gusdcruz in general you have data in tables along with the the lookup and bidge tables you need and then build meausres you need along with visuals to display the results. Sometimes calcualted tables and columns come in handy but in general try to avoid them when possible. Measures are calcualted only when needed and columns are calculated for every row. With large data sets this can be very inneficient and in most cases is not necessary. Plus doing it in measures and visuals lets PowerBI do the work for you in context.
@Seward12533, do you recommend me creating a new table with this new measure? I agree that I am forcing an Excel approach here, and you are correct I am a new user 😉
thank you for your time
@gusdcruz in general you have data in tables along with the the lookup and bidge tables you need and then build meausres you need along with visuals to display the results. Sometimes calcualted tables and columns come in handy but in general try to avoid them when possible. Measures are calcualted only when needed and columns are calculated for every row. With large data sets this can be very inneficient and in most cases is not necessary. Plus doing it in measures and visuals lets PowerBI do the work for you in context.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |