Forum Discussion

shady_hamilton's avatar
shady_hamilton
Regular Visitor
7 years ago

Filter on table and column

Hello, i have two tables, one that has the stock of each product and the second has a cloumn that has the names of the products purchased. each row of this column contain one product purchased, so if i want to know how many toys i purchased i count how many rows has "Toys" in them.

 

I want to create a varialbe that will give me the available stock from each product (stock - purchased) when i select the product name from a dropdown menu (a filter of the prduct name) 

 

what is the best way to create this please

Need Help

12 Replies

  • Omega's avatar
    Omega
    Impactful Individual
    7 years ago

    Can you please share a sample excel/PBIx file for the data set and the expected result? Thanks!

    • shady_hamilton's avatar
      shady_hamilton
      Regular Visitor
      7 years ago

      Hello Khader,

       

      I am attaching the example. the first sheet has the column of the purchases per day and the other sheet has the purchased stock per date.

      I want to know how much stock left from each product by selecting the name of the item from a drop down menu, when selected it will tell me how much purchased and how much stock left.

       

      many thanks,

       

       

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi shady_hamilton,

         

        Maybe something mistake. We cannot see your sample data. Please upload your sample data and the desired output so that we could help further on it.

         

        Best  Regards,

        Cherry