Conditional Formatting within Tooltip

Thanks, I'm confused because we already have a Variable called NonBlankValues which I thought would do this?

Anyway, my measure is a simple count:

Primary Topic Count = 
COUNT('Cases'[PrimaryTopic2])

I have another measure that I use to to count items in the current month which I've modified to use here but I still get the same issue.

ISINSCOPE New Topics = 
IF(
    ISINSCOPE(Date2[Mth]), -- Row Level (month) in scope so normal YTD logic
    TOTALYTD(
        COUNT('Cases'[PrimaryTopic2]),
        'Cases'[Created On]
    ),
    -- Total level (month is not in scope so each visible mth is iterated)
    SUMX(
        VALUES(Date2[Mth]),
        TOTALYTD(
            COUNT('Cases'[PrimaryTopic2]),
            'Cases'[Created On]
        )
    )
)

I still get the exact same results as before with MIN appearing in months in the future.
These NULLs are because the months are in the future so they are not INSCOPE?

I'm not sure how to fix this.

Correct me if i'm wrong but its the fact that Feb & Mar are appearing that is causing this?
(This pbix file hasn't been refreshed since mid January).
I thought ISINSCOPE would Filter out future months?

Hi ArchStanton ,

This behavior is expected due to the way tooltips handle filter context. When a measure is calculated in a tooltip, it is evaluated only for the specific data point being hovered over, such as a single month. Consequently, the measure does not automatically access all months needed to determine minimum or maximum values. This is why the same DAX expression works in the matrix but not in the tooltip.

To resolve this, you need to explicitly expand the filter context within the measure, allowing evaluation across all relevant months while still respecting slicer selections. Using ALLSELECTED on the month field ensures visibility into the full range of values, and filtering out blanks prevents empty periods from being considered as the minimum. With these adjustments, min and max calculations will work consistently in both matrix and tooltip views.

Thank you.

Hi, thanks again for the reply.
My DAX knowledge isn't the best, I'm still learning, would you be able to help with the code on this please?

Hi ArchStanton ,

This behavior was happening because when a report tooltip is triggered, the hovered month applies a strong filter context to the measures. As a result, the minimum and maximum values were being evaluated only for that specific month instead of across all visible months.

To address this, the month-level filter was explicitly removed within the calculation while still respecting slicer selections. With this adjustment, the tooltip now correctly shows the current month’s value along with the minimum and maximum across all visible months.

Please refer to the attached PBIX file for the updated implementation.

Best Regards,
Tejaswi