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.
Hi All,
I have an report in PBI that allows the end user to input their own targets (SLA's) by adding a numeric parameter for each of the 4 SLA's
SLA 2 Target = GENERATESERIES(0, 50, 1)
SLA 2 Target Value = SELECTEDVALUE('SLA 2 Target'[SLA 2 Target])
It works well proving I use [SLA 2 Target Value] on the same page as the slicer containing the series. Outside this page the measure does not work as expected
I have managed to pass the value to other report pages by syncing hidden slicers, but what I really need to do is use the value in an IF statement for a new dax column.
For example if the user entered the value '10' into the slicer:
This works
New Column Outcome = IF( Table[SLA 2 Days] > 10, "Out of SLA", "Completed In Time")
This does not work
New Column Outcome = IF( Table[SLA 2 Days] > [SLA 2 Target Value], "Out of SLA", "Completed In Time")
Any help appreciated
All the best
Vicky
Solved! Go to Solution.
@vickyw Columns are not dynamic, they are calculated at the time of data refresh. You need to implement as a measure instead.
@vickyw Columns are not dynamic, they are calculated at the time of data refresh. You need to implement as a measure instead.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |