CalculatedColumn Index

[TK12345]

Hi,

Could someone help me with a calculated column index. 

I have the following data:

Sort	Test	Value	Outcome
1		1	1
2		1	2
3	test	0	2
4		1	3
5		1	4
6		1	5
7		1	6
8		1	7
9	test	0	7
10	test	0	7
11	test	0	7
12		1	8
13		1	9
14	test	0	9
15		1	10
16	test	0	10
17	test	0	10
18		1	11
19	test	0	11

Index needs to start with 1, if the column on the left is empty then I need +1 for the index column. I have tried the following:

Column = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))

But this was to heavy or something to calculate and it crashed. 

How do I need to do this with a calculated column? Needs to be calculated column because the other columns are calculated as well.

[v-rzhou-msft · Accepted solution]

Hi @TK12345 ,

As far as I know, there should be a column as a condition for calculated index column, such as [Date],[Value]... and so on. I couldn't find a column which could be condition in your above table. Is [Sort] column a calculated index column in your table and your calculation is heavy or something to calculate and it crashed? I think calculation is based on data model, here I suggest you to try to optmize your data model or your code and try again.

For reference:

Optimization guide for Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.