Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Help filter

Good morning all,


I need your help for my power BI.

 

Here is my problem, I have a "Stock_Table" table where I have 6 columns

 

  • Date of extraction
  • MaterialCode
  • Factory stock
  • Supplier Stock
  • Needs
  • Remaining stock

 

what I want to set up in this table is a filter system which is as follows :

 

I want to have a filter that gives me only three possible choices:

  1. A Factory vision
  2. A supplier vision
  3. Global Vision

I then want to create a column in DAX which gives me the remaining stock (stock - needs = remaining stock)

what I want to do is that when I filter on Supplier Vision filter it only takes my supplier stock - needs = remaining stock

or for example: when I filter on Global Vision view, it calculates the remaining stock in this way: (factory stock + supplier stock) - the needs.

Or when I filter on Factory vision, the calculation of the remaining stock column does this way:

Factory stock - Need = remaining stock

 

 

If it is possible I would like not to create a new table but that all are included in the Stock Table 

 

Thanks a lot for your help !

  • Anonymous 
    I can open the file successfully, which version of PBI do you have?
    I will give you my method.
    1st, Create a separate table, without creating relationships with other tables, and put column Vision on the canvas as a slicer

    2nd Create a measure just like this and put it in your matrix.

     

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello jameszhang0805 ,

       

      many thanks for your help, unfortunately I can't open your PowerBi file.

      how do I do it

      • jameszhang0805's avatar
        jameszhang0805
        Resolver IV

        Anonymous 
        I can open the file successfully, which version of PBI do you have?
        I will give you my method.
        1st, Create a separate table, without creating relationships with other tables, and put column Vision on the canvas as a slicer

        2nd Create a measure just like this and put it in your matrix.