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.
Hello.
I divide a column (from a table) by a measure (from another table) and it does not seem to be working. Some rows work but most do not divide well. Inventory divided by Sales per week.
Any ideas? Thanks.
WEEKS TO SELL =
DIVIDE(SUM(Item_Card[Inventory]),[Sales/Week])
Solved! Go to Solution.
I assumed you had other columns in your table visual. Is that the case? Either way, I'm sure you already put that back to Don't Summarize. What are those columns? And how do the table(s) they are from relate to your other tables? More info about your model is needed to troubleshoot further. The default aggregation was potentially a quick fix (that didn't work).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If you pull down the arrow on the Inventory column, what aggregation is selected? Try choosing Sum if it is not that already. Or choose Don't Aggregate.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat ,
I switched it from Don't summarize to Sum but this is what the inventory column becomes.
I assumed you had other columns in your table visual. Is that the case? Either way, I'm sure you already put that back to Don't Summarize. What are those columns? And how do the table(s) they are from relate to your other tables? More info about your model is needed to troubleshoot further. The default aggregation was potentially a quick fix (that didn't work).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat ,
Thank you so much. I checked the table relationships and pulled the product number from a related table and everything works now. Thanks again.
In your visual, do you have an aggregation on your Inventory column? I'm guessing it's set to Average, Min, or Max. Try setting it to Sum to match the math in your measure.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat ,
Thank you for your quick reply. It looks like the inventory column just comes straight from a table. Would there be a reason why the DIVIDE measure is not working?
Thanks again.
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 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |