Forum Discussion

sandy8910's avatar
sandy8910
Frequent Visitor
5 years ago

DAX

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 

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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