Forum Discussion
How to show total as an average in matrix visualization?
HI hohlick Anonymous,
Supposing you have a Calendar or Date table dedicated to Time Intelligence.
[LoanMeasure] = AverageX( Values(Calendar[Month] ) , Calculate ( Sum( 'Fact'[LoanAmount] ) ) ) also works and doesn't need any IF statement.
Even better, use interim measure:
[SumOfLoanAmount] = Sum( 'Fact'[LoanAmount] )
And use this measure:
[LoanMeasure] = AverageX( Values(Calendar[Month] ) , [SumOfLoanAmount] )
A measure automatically wraps a "Calculate" which activates context transition.
Solution SageHI hohlick Anonymous,
Supposing you have a Calendar or Date table dedicated to Time Intelligence.
[LoanMeasure] = AverageX( Values(Calendar[Month] ) , Calculate ( Sum( 'Fact'[LoanAmount] ) ) ) also works and doesn't need any IF statement.
Even better, use interim measure:
[SumOfLoanAmount] = Sum( 'Fact'[LoanAmount] )
And use this measure:
[LoanMeasure] = AverageX( Values(Calendar[Month] ) , [SumOfLoanAmount] )
A measure automatically wraps a "Calculate" which activates context transition.
Hi Datatouille
Your solution worked well and now I am able to get quarter average.Thanks a lot for that. I do have a different query now. I am displaying data for three days for the month of July and August as seen in the screenshot.
Even though for a quarter it is showing average , thanks to your solution. It is summing up the data for the three days. I would like average for that too. How can that be achieved?