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 column on my data, but is not dynamic by months/ids filtered.
Thank you!
- 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!
4 Replies
- 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])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!
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]))