Matrix: how to add a (dynamic) Calculated Column ?

[jup0]

Hi all,

I created a matrix:

City | Confirmed | Cancelled

-------------------------------------------------

Berlin | 1.560.452 | 785.542

London | 1.102.210 | 425.254

Rows: City

Columns: JobStatus

Values: JobPrice

Now I want to add a calculated column at the end (after Cancelled colum) with the formula:

Rate = confirmed-column / cancelled-column

Result should be:

City | Confirmed | Cancelled | Rate

-------------------------------------------------

Berlin | 1.560.452 | 785.542 | 1,9864

London | 1.102.210 | 425.254 | 2,5918

Could you help me please?

[Floriankx]

Hello just add a calculated colum

Rate=DIVIDE([Confirmed],[Cancelled])

Best regards.

[jup0]

But where do I have to add these column? In the matrix diagram or in the data table?

Take a look at the screenshots please:

Thanks

[Floriankx · Accepted solution]

Hello you can create seperate Measures:

Canceled=COUNTROWS(FILTER(DataTable,[Status)="Canceled"
Confirmed=COUNTROWS(FILTER(DataTable,[Status)="Confirmed"

Ratio=DIVIDE([Confirmed],[Canceled])

Maybe you could create a table directly out of your data, but I'm not familiar with this.

It would be helpful to know more about your DataTable structure for further support.

Best regards.

[jup0]

Great! You did it !!!

My way:

xCountJobsCanceled = COUNTROWS(FILTER(Tabelle1;Tabelle1[Job.Status]="Canceled") )

xSumJobsCanceled = SUMX(FILTER(Tabelle1; Tabelle1[Job.Status]="Canceled");Tabelle1[Job.Total])

xSumJobsConfirmedCanceledRatio = DIVIDE([xSumJobsConfirmed];[xSumJobsCanceled])

xSumJobsConfirmedCanceledRatioText = FORMAT([xSumJobsConfirmedCanceledRatio];"0.#") & " : 1"

[Floriankx]

You're welcome.

I would appreciate my post to be marked as answer.

Best regards.