Forum Discussion
Power BI Table Visual pulling data that's not actually connected to the row item...
Your data model looks slightly suspicious. Can you refactor it into a proper dimensions/facts model?
Why does water not have a number? Milliliters? Or is it one of these infuriating recipes that says "add water as needed" ?
None of the tables are my own. I'm pulling from other sources. I can take a look at the middle tables though, and see if I can set those up as dimension tables.
The data point table is just a generic example. I guess it would technically be zero for my purposes, but it doesn't have a line item in the original data table (pulled from a source I do not own). Since it could theoretically be possible for other ingredients not to exist in that table I would rather understand why it is acting this way (vs returning a blank) than to just add a condition to set it to zero.