Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
https://drive.google.com/file/d/181kKsNnm5i7Hfzx4ZERCDLywPzJ0kPM7/view?usp=share_link
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
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |