Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Curtis Mobley]

Hello,

I am using a measure in a matrix and the Row total is not correct, the total is the Q1 amount only (see below).  I would expect it to be the sum of the Q1 and Q2 amounts.

Measure for Rebate Amount

_mRebate Amount =

CALCULATE(SUM(‘Rebate Invoices'[Rebate Amount]),

FILTER(‘Rebate Invoices’,

‘Rebate Invoices'[_cClose Date Qtr YYYY] = ‘_Date Time Slicer'[_mDate Qtr YYYY Selected]))

Any suggestions/ideas would be greatly appreciated.

Thank you,
Curtis

——————————
Curtis Mobley
Scottsdale AZ
4803486029
——————————

[Hasham Niaz]

Hi !

Can you give it a try;

_mRebate Amount =
CALCULATE(SUM('Rebate Invoices'[Rebate Amount]),
FILTER('Rebate Invoices',
'Rebate Invoices'[_cClose Date Qtr YYYY] <= '_Date Time Slicer'[_mDate Qtr YYYY Selected]))

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-