Problems with switch( True()

[Mightystomp]

This code return error code "Argument '4' in SWITCH function is required." I cannot see anything wrong with it but I think it mistakes the last entry as another value in stead of the else.

=switch(True()

;[HasoneValue]=1;

rankx(all(Test[Provider]);[Total Rev];;;dense);

;[Hasonevalue]=2;

blank();

;[hasoneValue]=3;

blank();

blank()
)

Can anyone see where I went wrong?

Thank you

 

[Matt Allington]

well it seems you have a couple of duplicate separators.

Try this

=SWITCH (
    TRUE ();
    [HasoneValue] = 1; RANKX ( ALL ( Test[Provider] ); [Total Rev];;; DENSE );
    [Hasonevalue] = 2; BLANK ();
    [hasoneValue] = 3; BLANK ();
    BLANK ()
)

 

[Mightystomp]

well it seems you have a couple of duplicate separators.

Try this

=SWITCH (
    TRUE ();
    [HasoneValue] = 1; RANKX ( ALL ( Test[Provider] ); [Total Rev];;; DENSE );
    [Hasonevalue] = 2; BLANK ();
    [hasoneValue] = 3; BLANK ();
    BLANK ()
)

Thank you. It works perfectly.

 

[Matt Allington]

Here's a tip. When you are stuck on your measure, copy the entire measure and paste it at DAX Formatter by SQLBI Make sure you select the correct separators for your country (top right hand corner). Then click format. DAX formatter normally will help you identify where you have made an error. Try it with your original formula that didn't work