KPI Card Target (MaxMonthlyExports) Not Showing Correct Value When Using Year 2024 Slicer

Hi everyone,

I’m encountering an issue with my KPI card visual where the target value (calculated by my MaxMonthlyExports measure) doesn’t show the correct maximum monthly exports for the selected year in slicer.

My Question

How can I modify my MaxMonthlyExports measure so that it correctly returns the maximum monthly exports for 2024?

Please refer to the below image, where I have hilighted the issue which is the Goal in yellow for the KPI card visual with title LatestMonthExports and MaxMonthlyExports by Year Month Number.

What I’m Trying to Achieve

I have a Power BI report that uses a slicer based on a date hierarchy (specifically, tDate[Year][Month]). When I apply the slicer for the year 2024, my KPI card visual is supposed to display the following:

• Value: The latest monthly exports using my LatestMonthExports measure.

• Trend Axis: The month ordering provided by tDate[Year Month Number].

• Target: The maximum monthly exports for the selected year (calculated by MaxMonthlyExports).

For example, under the 2024 slicer:

• Expected LatestMonthExports: 2599

• Expected Target (MaxMonthlyExports): 3074 (from October 2024)

Instead, both the value and the target show 2599 (with the target label showing 2024-12), meaning the KPI card target is returning the same value as the latest month’s exports, rather than the maximum across all months.

The tables responsible:

tExports and tDate(calculated table)

Table Relationship:

Data: 

tExports:

tDate

Measures Involved

Here are the DAX measures I’m using:

• LatestMonthExports

LatestMonthExports = 
VAR LatestDate = LASTDATE(tExports[weekEndingDate])
VAR LatestEOM = EOMONTH(LatestDate, 0)
VAR Result = 
    CALCULATE(
        SUM(tExports[weeklyExports]),
        EOMONTH(tExports[weekEndingDate], 0) = LatestEOM
    )
RETURN
    Result

• MonthlyExports

MonthlyExports = 
VAR Result = 
    CALCULATE(
        SUM(tExports[weeklyExports])
    )
RETURN
    Result

• MaxMonthlyExports

MaxMonthlyExports = 
VAR Result = 
    MAXX(
        VALUES(tDate[Month Year]),
        [MonthlyExports]
    )
RETURN
    Result

• MaxMonthToolTip

MaxMonthToolTip = 
VAR MaxMonth =
    SELECTCOLUMNS(
        TOPN(1, VALUES(tDate[Month Year]), [MaxMonthlyExports], DESC),
        "MaxMonth", tDate[Month Year]
    )
RETURN
    MaxMonth

How to Reproduce

1. Apply the Year slicer for 2024.

2. Use the KPI card visual with:

   • Value field: LatestMonthExports

   • Trend Axis: tDate[Year Month Number]

   • Target field: MaxMonthlyExports

3. Observe that the KPI card shows 2599 for both the value and the target, with the target’s label showing 2024-12, even though the correct maximum should be 3074 (occurring in October 2024).

I have attached the sample Excel data source and the Power BI (.pbix) file for reference. [Link](USDA FAS ESR)

Any help or suggestions would be greatly appreciated! 

Thanks in advance for your assistance.