Forum Discussion
snow87
Helper I
Helper IIf there are multiple values, which do reports use?
I have data like this: id recipe run 001 blue 1 002 green 1 003 red 1 001 green 2 002 green 2 How does PowerBI handle id 001? Will a report use blue or green ...
see attached
snow87Helper I
Helper IThe first table, with the recipes and the runs is fact, and the second table with the color grades is dimension, but this is my first time doing this so they might not be set up as strictly as a professional would. They have a many-to-one relationship. (The ids appear multiple times in the first table, and once in the second table.)
