Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |