cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Marcia1 Frequent Visitor
Frequent Visitor

Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

I am working with inventory data.

 

Imagine you have :

  • 3 products: P1, P2 and P3.
  • 2 sales locations: L1 and L2
  • 2 What-if Paramaters for a user to enter:  (a) the minimum quantity needed, Q and (2) the time taken to get the product, t

Also imagine I have 4 slicers at the top of my report:

  1. At the top of my report, the user enters values for the 2 What-if Parameters in 2 of the slicers
  2. The other 2 slicers are used to select to select P2 as the product and to select L1 as the sales locations.

 

How can I capture the information here as:

L1 | P2 | Q | t?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

Hi @Marcia1,

You don't need to create a new table you can use the measures to create the table visual or use it in other measures for the IF statement.

Can you share some more insights on what you want to achieve?

Regards,

MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




4 REPLIES 4
Super User
Super User

Re: Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

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.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Marcia1 Frequent Visitor
Frequent Visitor

Re: Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

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.

Super User
Super User

Re: Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

Hi @Marcia1,

You don't need to create a new table you can use the measures to create the table visual or use it in other measures for the IF statement.

Can you share some more insights on what you want to achieve?

Regards,

MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Marcia1 Frequent Visitor
Frequent Visitor

Re: Capture Slicer Values of What-if Parameters Based on Slicers on Fields in Another Table

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!