topic Re: My measure not returning correct subtotals in DAX Commands and Tips

My measure not returning correct subtotals

Anonymous — Sun, 06 Apr 2025 14:08:18 GMT

Why is my measure not pulling in right subtotals.

Please see the measure (unfortunaely I can't share the source data as its has critical company info)

YTD Actual =

CALCULATE(

'Sales Data file xlsx'[Total Actual],

FILTER(

ALL('Sales Data file xlsx'), -- Remove the calendar date filter

YEAR('Sales Data file xlsx'[Calender Date]) = 2025 &&

'Sales Data file xlsx'[Calender Date] >= EOMONTH(DATE(2025, MONTH(TODAY()), 1), -4) + 1 &&

'Sales Data file xlsx'[Calender Date] < EOMONTH(DATE(2025, MONTH(TODAY()), 1), -1) + 1

'Sales Data file xlsx'[Region] = SELECTEDVALUE('Sales Data file xlsx'[Region]))

The total I am excpecting needs to take into consideration the region filtered in the matrix table. But instead I think its reading blank.

Re: My measure not returning correct subtotals

Sahir_Maharaj — Sun, 06 Apr 2025 16:53:38 GMT

Hello Anonymous,

Can you please try this updated approach:

YTD Actual = CALCULATE( [Total Actual], FILTER( ALL('Sales Data file xlsx'[Calender Date]), YEAR('Sales Data file xlsx'[Calender Date]) = 2025 && 'Sales Data file xlsx'[Calender Date] >= EOMONTH(DATE(2025, MONTH(TODAY()), 1), -4) + 1 && 'Sales Data file xlsx'[Calender Date] < EOMONTH(DATE(2025, MONTH(TODAY()), 1), -1) + 1 ) )

Re: My measure not returning correct subtotals

v-prasare — Tue, 15 Apr 2025 04:59:43 GMT

Hi Anonymous, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Sahir_Maharaj , Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: My measure not returning correct subtotals

v-prasare — Mon, 21 Apr 2025 11:42:22 GMT

Anonymous,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: My measure not returning correct subtotals

v-prasare — Thu, 24 Apr 2025 05:01:06 GMT

Hi Anonymous,

Thanks for reaching MS Fabric community support.

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue your facing is resolved? or you still need any help here.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query