Calculated measures in Matrix row and columns

[tcr]

Hi,

We are trying to achieve this form in the PBI

but values on the left hand side are actually calculated measures in the PBI like

Active DD Donors =

CALCULATE(

    DISTINCTCOUNT('Pledge'[Pledge Reference]),

    FILTER('Pledge Details','Pledge Details'[Pledge Status]="Active"))

is there any way how we can calculate current year, current month, averages etc. and put them in the columns in the matrix.

This is what we have for now - measure calculations on monthly basis , but we struggle a little bit how to calculate for instance measures on monthly, year basis and average and put them in the columns.

Thanks

[tcr]

Hi @Mahesh0016 

Yes but that requires to create 100 measures for current Month Sales, I've managed this in the calculation groups, but since we have 2 measures on the matrix row,

one is Count and another is value, I'm not sure how to put them into one row and show count and value in colums, take a look picture below, we calculated new measures

No of New supporters Count, No of New Supporters Value, Active DD Donors Count,

Active DD Donors Value etc. , and we are not sure how to have one line for each measure while to put count and value in columns

[Mahesh0016]

@tcr I hope this helps you!THANK YOU!!
For E.g
CurrentMonthSale =
calculate ([Total Sale], Filter(Table, Table[Month]=Month(today()))

CurrentYearSale =
calculate ([Total Sale], Filter(Table, Table[Year]=Year(today()))