Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 JoseGarcia
		
			JoseGarcia
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I need expression below to ignore field: Customer_responded
Using this expression, but still not ignoring field.
Any ideas? 
My expression:
count(distinct {<PeriodType = {'YTD'}, Customer_responded=, Flag_First_planned={'1'}, Planned_Project= {'1'}>} [%Key_Fact])
Thanks as always
 BrunPierre
		
			BrunPierre
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try this
Only({<Customer_responded>} Aggr(Count Distinct({<Customer_responded,PeriodType = {'YTD'}, Flag_First_planned={1},Planned_Project= {1}>} [%Key_Fact]), PeriodType ,Flag_First_planned, Planned_Project))
 JoseGarcia
		
			JoseGarcia
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		@BrunPierre, 
Thanks for the support! 
Tried version. did not return expected values 😞
 BrunPierre
		
			BrunPierre
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		However, was the selection in the Customer_responded field disregarded?
 JoseGarcia
		
			JoseGarcia
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		When I applied the Customer_responded filter, field was not disregarded.
 BrunPierre
		
			BrunPierre
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Count(DISTINCT{<Customer_responded=>} If(PeriodType='YTD' and Flag_First_planned='1' and Planned_Project='1', [%Key_Fact]))
 JoseGarcia
		
			JoseGarcia
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Formula works but when I apply customer_responded applies value. 
I added two snapshots, I think issue may be that I have two date fields?
