DAX

[sandy8910]

Hi,

Need help

I have one table. Table has 4 columns

1. Inventory no.

2. Inventory State

3. Employee Name

4. Employee state

Now to I need to see in which state I have high inventory and low employee count. so basically Inventory vs. Employee availability. It can be shown on maps or in any other best visual

Please help as how to calculate that. If I take Inventory state and plot total inventory with Total employee. It shows the data as per Inventory state and vice a versa for Employee data.

Thanks 

[v-easonf-msft]

Hi , @sandy8910 

For now, there is no content of description in the thread.

If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[TomMartens]

Hey @sandy8910 ,

this seems like a broad question, and almost like project envisioning.

Please take some time and create a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

Describe your expected result based on the sample data you provide.

Regards,

Tom