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.
This Measure returns the amount of wages paid to employees who have been employed >= the number of weeks selected in the Wks Employed slicer.
The second slicer, 'What if Wage increases by' shows what the wages would be if they were increased by selected value.
What if Wages ? = CALCULATE([Pay Finalised] * [Wage Increase Value], FILTER(CarersList,[Wks of Employment _] >= 'Wks Employed'[Wks Employed Value]))
What I'm trying to show is the total What if Wages ? if the selected What if Wage increases by is only applied to people who have been employed >= the number of Wks Employed slicer. So I need to show What if Wages ? regardless of how many weeks employed but only apply the increase to those employed >= 23 for example (in the pic below).
Hi @android1
May be
What if Wages ? = SWITCH ( TRUE (), SELECTEDVALUE ( 'Wks Employed'[Wks Employed Value] ) = SELECTEDVALUE ( CarersList[Wks of Employment _] ), CALCULATE ( [Pay Finalised] * [Wage Increase Value], FILTER ( CarersList, [Wks of Employment _] >= 'Wks Employed'[Wks Employed Value] ) ), [Pay Finalised] )
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |