User selected date fetch dynamic values in visual

Hi , I have written view which fetch activity details of each user , Columns include ID, Activitydate, Name and other. So My requirements is If user selects any date from date slicer then my table visual should show id,name, Last 30 days , Last 90 days like that. So I have created a date table which has dates from 2017-01-01(Since date activity date starts from 2017-01-01) to today's date . Fuctinality should be : 1.User selected date > Activitydate of user , Then user selected date should be deducted by all activity dates of each user and the result we get in days. 2. If the day is <=30, then it should show 1 in that Last 30 days calculated column(Since i need to create card visual for count of Last 30 days for each user)that is why iam mentioning calclulated columns. Note : So I have created a date table which has dates from 2017-01-01(Since date activity date starts from 2017-01-01) to today's date . and created a measure 1.User selected date = calculate(SELECTEDVALUE('Date'[Date]),ALLEXCEPT('Date','Date'[Date])) 2.I have created another measure for Daycount selectActivityDate = calculate(SELECTEDVALUE(vw_MemberactivityonUserdate[activitydate]),ALLEXCEPT('vw_MemberactivityonUserdate','vw_MemberactivityonUserdate'[activitydate])) Daycount = IF([selectMeasure]>[selectActivityDate],DATEDIFF([selectMeasure],[selectLAD],DAY)*-1,"Novalue") 3.Last30 = if([Daycount]>0 &&; [Daycount]<=30,1,blank()) 4.Last90 = if([Daycount]>30[Daycount]<=90,1,blank()) I have created all these measures. But in table visual iam getting all the activitydates of each user (If user has 10 activity dates iam gettiing 10 rows), End result should be : 1.I need to show table visual which get only one row for each user with ID, Name, lastactivitydate(means max of lastactivity), Last 30 days, Last 90 days 2.I need to shoe card visual which shows count of id for Last 30 days based on user selected date as well as for Last 90 days