Help with averages and cross filters

[Syndicate_Admin]

Hello friends. I have the following related tables. In the table above it shows the total consumed by "surgery", in the table below it shows the detail of all the inputs used.

The problem I have is that in the table below, I need to compare the supplies used and the average use of said supplies in a similar surgery. I want this when I filter some data from the table above.

In logical terms, I need: first of all, to calculate the average by inputs (number of inputs / number of surgeries), and if I select something from the table above, to calculate (number of inputs / number of surgeries) by service_performs

Attached sample file. Thanks a lot!!

ARCHIVO PBI

https://drive.google.com/file/d/181kKsNnm5i7Hfzx4ZERCDLywPzJ0kPM7/view?usp=share_link

[v-cgao-msft]

Hi @Syndicate_Admin ,

If I understand correctly, the formula should be similar to this:

Measure = IF(ISFILTERED('Cirugias'[Nº Cirugia]),[AVERAGE1],[AVERAGE2])

//In logical terms, I need: first of all, to calculate the average by inputs (number of inputs / number of surgeries), and if I select something from the table above, to calculate (number of inputs / number of surgeries) by service_performs

But I failed to understand the sentence, how should they be calculated?

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum