Forum Discussion
Solved
Creating an Average Column/Measure Combining multiple Specific rows over two tables
Hello all 🙂 I'm hoping someone can help me with this problem. I have the dataset in the screenshot below. I need to create a column (or measure) it doesn't matter which one as long as I can plo...
HI ScarlettBebb,
You can write a measure formula to use these fields as group to filter on the aggregate calculations:
formula = CALCULATE ( AVERAGE ( Table1[Lot] ), ALLSELECTED ( Table1 ), VALUES ( Table1[Part Number] ), VALUES ( Table2[Well Position] ), VALUES ( Table1[QA Sample Point] ) )If the above not help, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
HI ScarlettBebb,
You can write a measure formula to use these fields as group to filter on the aggregate calculations:
formula =
CALCULATE (
AVERAGE ( Table1[Lot] ),
ALLSELECTED ( Table1 ),
VALUES ( Table1[Part Number] ),
VALUES ( Table2[Well Position] ),
VALUES ( Table1[QA Sample Point] )
)If the above not help, can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng