Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Frequent 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
Super User
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 Super User!

Power BI Blog

Frequent Visitor

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
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 Super User!

Power BI Blog

4 REPLIES 4
Super User
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 Super User!

Power BI Blog

Frequent Visitor

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!

Frequent Visitor

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
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 Super User!

Power BI Blog

## Helpful resources

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors