Forum Discussion
Custom if statement
Hello! I am trying to write a switch statement (or an if statement), but it's not working correctly. I want to create an equation/statement that takes the number for the minimum no of tms (the...
That idea works yes - but I'm having trouble putting it into my report. It unfilters everything when I put that measure into the table. It's not grouping the data like I wanted....
Development Status =
VAR variable1 = SELECTEDVALUE(V_TM_ModulePowerBI[ProficiencyNumber])*3
VAR variable2 = count(V_TM_ModulePowerBI[EmployeeName])*3
return
if(variable1 >= variable2, "YES", "NO")
Hi nataliesmiy1357 ,
I think your logic is
if (count(employee name) with score >= 3 is greaterthan or equal to minumum number of tms, yes, no)
I am confused about your countof [EmployeeName] or current [ProficiencyNumber] will multiply by 3.
I couldn't find V_TM_ModulePowerBI[ProficiencyNumber] and V_TM_ModulePowerBI[EmployeeName] in your screenshot. Please show me a screenshot of your table. This will make it easier for us to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.