Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to get Rank values without blanks

how to get rank values from starting from 1 when the rest values are blanks  
DAX
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Rank =
if(
	HASONEFILTER( T[Name] )
	&&
	[Total Sales] <> 0,
	
	RANKX(
		FILTER(
			ALLSELECTED( T[Name] ),
			[Total Sales] <> 0
		),
		[Total Sales],
		,
		ASC,
		Dense
	)
	
)

 

Best

D