DAX Help filter

[Anonymous]

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 !

[jameszhang0805]

Hope it's help 

Stock Vision.pbix 

[Anonymous]

Hello @jameszhang0805 ,

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

how do I do it

[jameszhang0805 · Accepted solution]

@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.