Forum Discussion

Frequent Visitor

8 years ago

Solved

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

Hi all, I created a matrix: City | Confirmed | Cancelled ------------------------------------------------- Berlin | 1.560.452 | 785.542 London | 1.102.210 | 425.254 Rows: City Columns...

Floriankx
8 years ago
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.

Frequent Visitor

8 years ago

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

Solution Sage

8 years ago

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
Frequent Visitor
8 years ago
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
  Solution Sage
  8 years ago
  You're welcome.
  
  I would appreciate my post to be marked as answer.
  
  Best regards.