set analysis syntax not working in a new dasboard

[ashishtams]

     Hi All

I have used a set anylysis syntax as below in the existing dashboard. This syntax works fine.

sum({$<[My Date]={"$(=date(MAX([My Date])))"}>}[total pass])

But now when i am trying to create a new dashboard and use the same syntax its not working. Just showing me '-' in all the  rows instead of the data. I think i have checked all the other options in the properties for this expression but no no luck.

anybody faced the same issue or any idea on this would really help.

Thanks,

Ashish

[stigchel]

Then [My Date] probably is not a proper date. Try with

sum({$<[My Date]={"$(=Max(date(date#([My Date],'YourDateFormat'))))"}>}[total pass])

[jonathandienst]

One can only guess with the limited information you provided. The problem could be

• [My Date] field does not exist, or is all null
• [My Date] is not a proper date (so Max(My Date) does not work properly)
• [total pass] does not exist, or is populated only with nulls
• Something is wrong with the association in the data model between these two field and/or the dimension