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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.