Set Analysis

[bhavvibudagam]

Hi Everyone,

I have write one set analysis expression like below

=(SUM({<Category = {'Ateam'}>}[Foot Ball Team]))

/

(SUM({<Category = {'Ateam'},Test_Date={'$(=(Max(Test_Date)))'}>}Total_team))

But here category = Ateam is not applying properly. When I have selected Ateam from the list box only its showing the correct result.

The selection need to apply from set analysis. Please find the app and source file.Pleas let me know Am i missed anything.

Thanks

[sunny_talwar]

Try this

=(SUM({<Category = {'Ateam'}>}[Foot Ball Team]))

/

(SUM({<Category = {'Ateam'},Test_Date={"$(=(Max({<Category = {'Ateam'}>}Test_Date)))"}>}Total_team))

[Anonymous]

=(SUM({1 <Category = {'Ateam'}>}[Foot Ball Team]))

/

(SUM({1 <Category = {'Ateam'},Test_Date={'$(=(Max(Test_Date)))'}>}Total_team))