Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

INDEX for table with DAX

Hello ,    I want to create index wiht DAX for following table. But I could not create a column  because working in Direct Query. That why I need a different solution.    The index that will be cre...
Interesting Links
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Yes,Sales price is measure. I want to add index column for power bi visual on above.
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

according the radacad RANKX bible from amitchandak link, you can try to create a measure like

	RANKX(
		ALL('Table') ,
		CALCULATE(
			SUM('Table'[Sales Price])
			)
	)