Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix visual - using a row total in a calculation

I am building a small, fairly simple report for my finance department.  They do analysis of total AR and AP transactions, per employee per day, per month and year to date. The data set is fairly sim...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Please try:

    Percentage = 
var _total = CALCULATE(COUNT('AR Transactions'[Voucher]),FILTER(ALL('AR Transactions'),MONTH('AR Transactions'[CreatedDate])=MONTH(MAX('AR Transactions'[CreatedDate]))))
return DIVIDE([ARTransCount],_total)

    Then change the format of the measure to percentage:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Please try:

Percentage = 
var _total = CALCULATE(COUNT('AR Transactions'[Voucher]),FILTER(ALL('AR Transactions'),MONTH('AR Transactions'[CreatedDate])=MONTH(MAX('AR Transactions'[CreatedDate]))))
return DIVIDE([ARTransCount],_total)

Then change the format of the measure to percentage:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.