Help getting a count with 2 filters in the same table

Question

I think its a very simple solution but I can't get the answer&nbsp;IDDescriptionDateCSProgrammed2/2/2023CSPurchase2/2/2023CSProgrammed3/10/2023CSProgrammed5/9/2023CSPurchase4/14/2023CJProgrammed1/30/2023CJPurchase1/30/2023CJProgrammed6/9/2023CJPurchase5/19/2023CIPurchase5/19/2023CIPurchase6/20/2023CIProgrammed4/28/2023CIProgrammed6/21/2023&nbsp;I want to count the amount of purchase that were made in the same day of the programmed by ID and then divide by another measureThis is what I have for now but I think I'm overcomplicating&nbsp;% of compliance =CALCULATE(&nbsp; &nbsp;&nbsp;COUNTX(&nbsp; &nbsp;&nbsp;ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SUMMARIZE(Data, Data[ID], Data[Date]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Data[Description]&nbsp;=&nbsp;"Purchase"&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"@same",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;var&nbsp;_dt&nbsp;= Data[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;return&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;VALUES(Data[Date]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;REMOVEFILTERS(Data[Date]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Data[Description]&nbsp;=&nbsp;"Programmed"),&nbsp; &nbsp;&nbsp;[@same]))/[Amount of weeks programmed to today])&nbsp;Someone told me to do it this way% of compliance =VAR _ProgrammedDates =&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES(Data[Date]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data[Description] = "Programmed"&nbsp;&nbsp; )RETURN&nbsp;&nbsp; DIVIDE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNTX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL(Data),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data[Description] = "Purchase"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;&amp; Data[Date] IN _ProgrammedDates&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data[ID]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Amount of weeks programmed to today]&nbsp;&nbsp; )&nbsp;But it also doesn't workPlease help

amitchandak · Accepted Answer

Anonymous , please find the attached file 
&nbsp;

&nbsp;

Forum Discussion

Help getting a count with 2 filters in the same table

1 Reply

Related content

Filter participant counts

Filter and Count

Counting nulls

get row count

Get count in filtered context

ID	Description	Date
CS	Programmed	2/2/2023
CS	Purchase	2/2/2023
CS	Programmed	3/10/2023
CS	Programmed	5/9/2023
CS	Purchase	4/14/2023
CJ	Programmed	1/30/2023
CJ	Purchase	1/30/2023
CJ	Programmed	6/9/2023
CJ	Purchase	5/19/2023
CI	Purchase	5/19/2023
CI	Purchase	6/20/2023
CI	Programmed	4/28/2023
CI	Programmed	6/21/2023