Comparing Scenarios in a specific order

[Anonymous]

Hi All,

I don't know how to fix this measure.

I have a table with multiple sales scenarios and need to compare them all vs a specific one ("CommMeeting") so I have this formula:

Var vs CommMetting = CALCULATE(sum(BestEstimateTot[Value]),BestEstimateTot[Total Channels]="CommMeeting") - CALCULATE(sum(BestEstimateTot[Value]))

and it works fine.

But I need to show the table in a specific order:

1 CommMeeting

2 Aligned

3 Marketing

4 Sales

So I created a table with these indexing and added to my model, creating a relation between the tables.

But when including the index in the table, it duplicates the scenarios:

any idea of how to fix the formula? or how to sort the table in a specific order?

Thanks

Fabian

[Nathaniel_C]

Hi @Anonymous ,

Not sure if I understand when you added the index. but have you tried the sort by column? The index will work if you have the table sorted before you add the index, if I understand to which table you have added it.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel