Forum Discussion
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:
- A Factory vision
- A supplier vision
- 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 slicer2nd Create a measure just like this and put it in your matrix.
3 Replies
- jameszhang0805Resolver IV
Hope it's help
- AnonymousNot applicable
Hello jameszhang0805 ,
many thanks for your help, unfortunately I can't open your PowerBi file.
how do I do it
- jameszhang0805Resolver 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 slicer2nd Create a measure just like this and put it in your matrix.