cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eliele
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!

 

Capture.PNG

3 ACCEPTED SOLUTIONS
GilbertQ
Super User
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

View solution in original post

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

View solution in original post

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

View solution in original post

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

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

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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors