Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |