Forum Discussion

jup0's avatar
jup0
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's avatar
    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.

jup0's avatar
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's avatar
Floriankx
Solution Sage
8 years ago

You're welcome.

 

I would appreciate my post to be marked as answer.

 

Best regards.