Forum Discussion
Measure Subtotals in Matrix not working for both Rows and Columns
hello, I added this Measure in a Matrix, which calculates the transactions volume by hour: Total Transactions = AVERAGE(table1[percentage_by_hour]) * sum(table2[transaction_value]) "table1...
thanks Anonymous , but unfortunately this won't work as I cannot have fields from different tables in the Summarize function.
Anonymous...
Anonymous, please download the Excel file and open the PowerPivot model. You'll then see how it's structured and the measure you want.
Best
D
Best
D