Clustered column chart - make tooltip use filters?

[Irwin]

Hi,

I have a clustered column chart. Here I want to display a percentage of tasks completed within a time frame as a YTD and Previous month. It looks like the below. The percentage is calculated from either a 1 (=the task is completed within the timeframe) or a 0 (=the task is completed outside the designated timeframe)

I have the "task" column as a tooltip. However it shows both with the entire amount of tasks for the year. Why?

My measures looks like the below.

YTD =

VAR OnTime = COUNTROWS(FILTER('TaskTable', 'TaskTable'[IS_OK]=1))

VAR Blanks = COUNTBLANK('TaskTable'[IS_OK])

VAR OffTime = CALCULATE(COUNTROWS(FILTER('TaskTable', 'TaskTable'[IS_OK]=0))-Blanks)

Return

DIVIDE(

        OnTime, OffTime+OnTime)+0

This Month =

CALCULATE(

    [YTD],

    DATESMTD(Calendar[CalendarKey])

)

Previous Month =

IF(    

    CALCULATE(    

        [This Month],    

        DATEADD(Calendar[CalendarKey], -1, Month)    

    ) = 0,    

    0,    

    CALCULATE(    

        [This Month],    

        DATEADD(Calendar[CalendarKey], -1, Month)    

    ) + 0    

)    

It makes no change whether I togle "keep all filters" on or off

[Ritaf1983]

Hi @Irwin 
The option "keep all filters" refers to drill-through functionality and not to tooltips.

According to your request, the measures that you put on the graph don't give filter context to the tooltip.
To assist more I need a data to work with so 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Irwin]

Thank you for your reply. Much appreciated.

Unfortunately the data is confidential. Could you perhaps instead guide me in the direction of some training material that explains more about filter context for tool tips? 

[Ritaf1983]

I need to understand what you trying to do 🙂

You can prepare some dummy pbix just to show the needed logic.