Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 vgadang1
		
			vgadang1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=if([Last Accessed Session] > 45, AppName, null()) This doesnt work as dimension but works as a measure, what am I doing wrong
Here is the output, Test column is expression =if([Last Accessed Session] > 45, AppName, null()) as master dimension, and Filtered apps column is same expression as master measure. Can someone help.
 mayuringale25
		
			mayuringale25
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi @vgadang1
Attaching a screenshot as the same is working on the side for both dimension and master dimension
Expression:IF([Last Accessed Session]>45,AppName,NULL())
 vgadang1
		
			vgadang1
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		so my Last accessed session is a measure which calculates days since app was reloaded interval(today(2)-daystart(max(LogTimeStamp)),'d'). Is it possible that my calculated dimension is referring to the measure has to do with the problem. I am still struggling with this calcuated dimension.
IS there an alternative solution to this? I just need to filter out the null rows from the table, is there a way to do that with a measure.
Thanks,
Vidya
 mayuringale25
		
			mayuringale25
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		