Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Set Analysis

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

2 Replies
sunny_talwar

Try this

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

/

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

Anonymous
Not applicable

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

/

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