Top 10 totals

[Ayden]

hello all I am trying to get the top 10 part for a specific date. I did the following.

sum({<Date = {"$(=vFisrtDate)"},[Part ] = {"=Rank(sum( [Balance Amount]))<=10"}>}[Balance Amount]).

looks like am missing some parts. Thanks all 

[BrunPierre]

Sum({<Date = {"$(=$(vFisrtDate))"},[Part ] = {"=Rank(sum( [Balance Amount]))<=10"}>}[Balance Amount])

[Ayden]

thanks for your response now that i updated with ur response this is what i now see in the date column. which does not help fix the issue. Thanks 

[BrunPierre]

Try

Date = {"$(=Date (vFisrtDate, 'DateFormat'))"}