Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |