Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago

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...
Data Protection
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey nataliesmiy1357 ,

 

using Power Query (M) here is a M snippet

if [Dim1] = "A" and [Dim2] = "B" then "this" else "that"

and the same using DAX to create a calculated column

if ( ( 'Table'[Dim1] = "A" && 'Table'[Dim2] = "B" ), "this" , "that" )

If this does not help consider creating a pbix using Power BI Desktop and uploading the file to your private onedrive or dropbox account (this is how most of us share files).

 

Regards,

Tom

nataliesmiy1357's avatar
nataliesmiy1357
Helper IV
4 years ago

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")

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.