Forum Discussion

tcr's avatar
tcr
Regular Visitor
3 years ago

Calculated measures in Matrix row and columns

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

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    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()))

  • tcr's avatar
    tcr
    Regular Visitor
    3 years ago

    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