I need to create index column on the visual

[Anonymous]

actual result

desired result 

i need dynamic index column on the visual based on price column  (price column should be in ascending order)

[Anonymous]

Hi @Anonymous ，

You could also use countrows() function.

column:

countrow_ = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[price]<=EARLIER('Table'[price])))

Measure:

count_rows = CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[price]<=MAX('Table'[price])))

Best Regards,

Jay

[Anonymous]

Hi jayw ,

I don't need index numbers based backend whole dataset, i need dynamic index for example
if i apply any filter the index value is recalculate

[Thejeswar]

Hi @Anonymous ,

If you are going to create  a column, it will not be dynamically indexing the records based on your selections.

The Only way to get dynamic nature to your index values is by creating measures.

You can check out the below two sugesstions on this

https://community.powerbi.com/t5/Desktop/I-need-to-create-index-column-on-the-visual/m-p/2465967#

https://community.powerbi.com/t5/Desktop/I-need-to-create-index-column-on-the-visual/m-p/2465967#

Regards,

[Greg_Deckler]

In addition the @Thejeswar you could also use the Mythical DAX Index. The Mythical DAX Index - Microsoft Power BI Community

[Thejeswar]

@Greg_Deckler ,

Sure let me check that out. Thanks!!

[Thejeswar]

Hi @Anonymous ,

You need to create a Rank based on the Price and Use this Rank Measure as your index column in the visual.

index :=

RANKX ( ALL (Table), 'Table'[price] ,, ASC)

When used in a measure

index :=

RANKX ( ALL (Table), CALCULATE(SUM('Table'[price])) ,, ASC)

[Anonymous]

Hi tejeswar , when i try to implement the same logi i got below error.

A single value for column 'Final Unit price with zeros' in table 'udm_sales_fact' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggr

[Thejeswar]

Hi @Anonymous ,

It clearly tells you what the error is!!

In a measure you have to use aggregate for a column. Like SUM(Table[Price]).

May be you can try this

index :=

RANKX ( ALL (Table), CALCULATE(SUM('Table'[price])) ,, ASC)

*Updated my previous reply as well