Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table with Hours & Wages Column.
I've applied a What If parameter: What if = [Wages] * [Wage Increase Value]
I only want to apply this What if to Hours = .5 but i still want to show total of all other hours also.
Solved! Go to Solution.
Just add IF Function and SELECTEDVALUE Function inside.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @android1,
You need to create a measure with a SUMX something like this:
What if = SUMX ( Table; [Wages] * [Wage Increase Value])
This will give you the sum of the multiplication values line by line.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Just add IF Function and SELECTEDVALUE Function inside.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |