I am working with inventory data.
Imagine you have :
Also imagine I have 4 slicers at the top of my report:
How can I capture the information here as:
L1 | P2 | Q | t?
Solved! Go to Solution.
Hi @Marcia1 ,
When you create a what-if table it automatically creates a parameter measure something similar to what is below:
Parameter Value = SELECTEDVALUE('Parameter'[Parameter])
Using this type of syntax allows you to capture the value of each of the values you need, just need to replicate this for each of the 4 slicers you have.
Thanks @MFelix . I can see how this works for each field but I want to make a table with 1 row....just to represent the unique combination of values that the user has selected in the report.
The table will have 4 columns and 1 row - giving the unique state of the user's selections for Location | Item | Quantity | Time. I need this resulting table to join onto another table to perform some IF / THEN statments to calculate a field.
Hi @MFelix ,
Thanks - i made sure the field I was creating is a measure and that it only looks at measures and not calculations as well.
Thank you for your help!