INDEX for table with DAX

Question

Hello ,&nbsp; &nbsp;I want to create index wiht DAX for following table. But I could not create a column &nbsp;because working in Direct Query. That why I need a different solution.&nbsp; &nbsp;The index that will be created with DAX must be ranked with Quanty and sales prices. Sales price and Quantity are directly proportional; when one of them increases other one also increases.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;The outout of DAXPower BI Vısual

parry2k · Answer

Anonymous&nbsp;so what exactly you are after, an&nbsp;Index column? How you are planning to use it? I guess&nbsp;sales price is a measure?

amitchandak · Answer

Anonymous , Not very clear you want to do.
&nbsp;
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

anonymous · Answer

Yes,Sales price is measure. I want to add index column for power bi visual on above.

az38 · Answer

Hi&nbsp;Anonymous&nbsp;
according the radacad RANKX bible from&nbsp;amitchandak&nbsp;link, you can try to create a measure like
	RANKX(
		ALL('Table') ,
		CALCULATE(
			SUM('Table'[Sales Price])
			)
	)

greg_deckler · Answer

Not exactly sure I get it. But, maybe check out&nbsp;

&nbsp;

To *Bleep* with RANKX!

&nbsp;
https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/td-p/1042520

Forum Discussion

INDEX for table with DAX

7 Replies

Related content

Multiple conditions Index

Index

Fixed Index Column

Index Key

Can we create indexs for temp table in Fabric?