Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
Hello just add a calculated colum
Rate=DIVIDE([Confirmed],[Cancelled])
Best regards.
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
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.
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"
You're welcome.
I would appreciate my post to be marked as answer.
Best regards.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |