Power BI Matrix Calculated Column

[eliele]

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!

[GilbertQ · Accepted solution]

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])

[eliele · Accepted solution]

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]))

[GilbertQ · Accepted solution]

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])

[eliele]

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!

[eliele · Accepted solution]

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]))

[GilbertQ · Accepted solution]

Well done, it is always an amazing feeling when you can solve it!