Forum Discussion
Solved
Power BI Matrix Calculated Column
I created the matrix below and I have page filters based on id and month. Is there a way for me to create a calculated column that does Failures/Flights? I tried creating it as an additional colu...
- Hi there
When you say a column that does Failures/Flights, would you want a combination of both of them?
If so you could create a New Measure with the following: Flights & Failures = SUM(Table[Flights]) + SUM(Table[Failures]) I solved it by creating a new measure instead of a new quick measure.
Flights/Failures = DIVIDE(SUM('Table'[Failures Count]),SUM('Table'[Flight Count]))- Well done, it is always an amazing feeling when you can solve it!
Hi there
When you say a column that does Failures/Flights, would you want a combination of both of them?
If so you could create a New Measure with the following: Flights & Failures = SUM(Table[Flights]) + SUM(Table[Failures])
When you say a column that does Failures/Flights, would you want a combination of both of them?
If so you could create a New Measure with the following: Flights & Failures = SUM(Table[Flights]) + SUM(Table[Failures])
Hi Gilbert,
No, I need Failures divided by Flights but it has to be dynamic based on the parameters chosen for the matrix.
I have Filters by ID and Month.
Thanks!