Error in TOP 3 Ranking with DAX

[fabo]

Hello there!

I'm just learning DAX so maybe this question isn't hard at all.  I found this Top 3 ranking example in other site X.  I tried to implement it from the scratch but I got an error I can't fix neither understand.

Table:

Measures:

Sum Value = SUM(Test[Value])

Rank Name =
IF(
   HASONEVALUE(Test[Name]),
   RANKX(ALL(Test[Name], Test[Value]), [Sum Value])
   )

Top 3 Cases =
IF(
   HASONEVALUE(Test[Name]),
   IF(
      [Rank Name] <= 3,
      [Sum Value]
   )
)

The error is highlighted in the measure Top 3 Cases:

The error is "the syntax of '[Sum Value] is incorrect".  

I downloaded the original files from that site X and the same error occurs.  I reviewed the comments looking for clues and I got nothing.

Maybe something in my Power BI Desktop settings is wrong.  Or maybe something else.  Any ideas, please?

Greetings!

[MFelix · Accepted solution]

Hi ,

I believe that is relatef with regional settings try to change your formula from:
[Rank Name] <= 3,
[Sum Value]

To

[Rank Name] <= 3,0,
[Sum Value]

Still no sure why but with my regional.setting when I need to add numbers to my syntax always need to add the decimals, probably because the decimal.symbol (comma) is the same as the separator in the formulas

Check if it works.

Regards,
MFelix

[fabo]

Hi @MFelix!

It works!  You were right.  It was a regional setting issue.  The code seems to be confunsing at first glance because 0 looks like the true argument in the IF statement and [Sum Value] looks like the false argument.  

Fortunately, we can use several lines and spacing to make it clearer.

Thank you for your help!

Best regards!

fabo