Forum Discussion
import and redesign data scheme
Hi rabers,
Let's assume that in the FACT table ~125k order items which belongs to ~31k OrderID.
When I create a bar chart with SalesPersonID as axis (dimension) and count distinct SalesOrders as value (metric) I get the same value (~31k) of SalesOrders per each SalesPersonID, where, in fact, there is a variance between each salesperson....
(for example SalesPersons A has 1000 orders, SalesPersons B has 3500 orders, etc.)
What am I missing here?
Would you please share more information, as you didn't mentioned SalesPersonID in your previous post? It would be better if you could share .pbix file for our analysis.
I noticed that the link between the newly merged table (Orders) and SalesPerson is weird, don't know why...
and one last thing, when tables were hidden - their relations didn't disappear automatically, shouldn't they?
As mentioned in my original post, you can manage the relationship manually. By default, when we hide the tables, relationship of hide tables will not be affected.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft
can you, please, check out what i've posted?
what's wrong with that?
i've read what you posted but still it's not working for me.
also,
when creating a newly merged table and hiding the original tables they just become grey BUT relations still exists at the ERD, is that the way it should be?