Greg Galloway on 26 Jan 2017 23:37:26
Let's say that I start a new report by adding the Inventory Quantity measure to a table. I get no indication in the field list that the Product and Warehouse tables are related to the measure in my table but that the Customer table is not. Please show some sort of indication of this such as greying out the unrelated tables or giving us a button which hides any unrelated tables. The biggest concern is that if I add Customer to my table, then the Inventory Quantity repeats since it's unrelated. This can cause confusion to users and performance problems.
Please do not prevent us from choosing unrelated tables as unrelated tables can impact the logic of DAX calculations in my measure.
- Comments (1)
RE: Grey out or hide tables that are unrelated in field list
Wondering why this is not requested more?
After 5 years of using power bi, we produce big models (many fact tables and many dimensions) and it is difficult to quickly see possible dimensions for a measure for analyst (impossible for end user). Often one can pick a measure with unrelated dimension and don’t notice that it produces incorrect result.
Suggested solution that when I pick a measure, unrelated dimensions would grey out, seems very good.