cancel
Showing results for
Did you mean:
Regular Visitor

## 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!

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User

## Re: Power BI Matrix Calculated Column

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Regular Visitor

## Re: Power BI Matrix Calculated Column

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

## Re: Power BI Matrix Calculated Column

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
4 REPLIES 4
Highlighted
Super User

## Re: Power BI Matrix Calculated Column

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Regular Visitor

## Re: Power BI Matrix Calculated Column

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!

Regular Visitor

## Re: Power BI Matrix Calculated Column

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

## Re: Power BI Matrix Calculated Column

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

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 94 members 1,487 guests
Recent signins: