Utilization of assortment - Combine two data sets and filter

[celfa]

Hi.

I'm trying to visualize the utilization of an assortment. I've got 2 tables with the following columns:

Sales data:

Order number | Identity | Option | OrderType | OrderStatus | Date | Key |

Configuration data:

Identity | Option | Key |

The sales table contains information about everything which has been sold.

The configuration table contains all possible configurations.

I want to compare these two tables in one graph. I've made a unique key for both tables which just is the value of identity and option. So there is a relation between these two tables. And I'm able to make a graph with is showing the count of options from each table. But my issues occurs when I want to filter on OrderType and OrderStatus, but the filter affects both my sales and my configuration data. And all graphs is just the same value.

Hope some of you guys can suggest a solution. Thank you 🙂

[v-shex-msft · Accepted solution]

Hi @celfa,

Can you share some sample data or detail content?  It will be help for troubleshooting.

In addition, I'd like to suggest you check the cross filter option first if it not set to "both".

Regards,

Xiaoxin Sheng

[celfa]

Hi @v-shex-msft

Thanks for your reply! I've actually just solved it. I've tried to change my relation from one to many to many to one and change the cross filter option and now it works. So thank you!