Commissions balance report

Hi pmargari ,

Since your screenshot doesn't show sales, it's not entirely clear to me how column E in your table is calculated. I did some calculations using my "financials" table and I hope this helps.
1. Create a measure, find the sum of sales per quarter, and display it in the last month of each quarter.

Measure =
VAR _sum_q = CALCULATE(SUM(financials[Sales]),FILTER(ALL('financials'),'financials'[Date].[Quarter] = MAX('financials'[Date].[Quarter])))
RETURN
SWITCH(MAX('financials'[Date].[Month]),
"March",_sum_q,
"June",_sum_q,
"September",_sum_q,
"December",_sum_q,
BLANK())

2. Create a new measure, find half of all sales, and then display it in December.

Measure 2 =
VAR _sum_y = CALCULATE(SUM(financials[Sales]),ALL('financials')) / 2
RETURN
IF(MAX('financials'[Date].[Month]) = "December",_sum_y,BLANK())

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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