Problem with sort & conditional formatting

[AndrejZitnay]

Hello all,

I am working on matrix where I have league table. I have there several columns but I am always facing same issue.

I need to have blanks or errors as blank without colour at the end of table after sort. Closest success I have is with blank() but they are in middle after sort.

1 - Contribution Margin Difference = IFERROR([Contribution Actual (Margin %)]-[Contribution Budget (Margin %)],BLANK())

2 - Contribution Margin Difference = IFERROR([Contribution Actual (Margin %)]-[Contribution Budget (Margin %)]," ")

3 - Contribution Margin Difference = IFERROR([Contribution Actual (Margin %)]-[Contribution Budget (Margin %)],"Check")

Can you help me?

[parry2k]

@AndrejZitnay only solution I can think of is to create a calculated table from your measure and add a sort column to achieve the result. see example below

[AndrejZitnay]

Hello @parry2k 

I will try that.

What is the best way to create calculated table?

My rows are just profit centres and I have in columns only measurements.

Many thanks.

Kind regards.

Andrej

[parry2k]

@AndrejZitnay try following DAX to create calculated table called Table Cont Margin

Table Cont Margin = 
SUMMARIZE( Table13, Table13[ProfitCenter], 
"Cont Margin Diff", [Contibution Margin Difference], 
"Margin Sort", IF ( [Contibution Margin Difference] = BLANK(), -9999999, [Contibution Margin Difference]) 
)