Conditional Formatting within Tooltip

[ArchStanton]

Hi

I have a measure that shows the Max and Min value in a Matrix - it works no problem.

However, I cannot get this to work as a tooltip - is it even possible?

MinMaxMeasure =
VAR ValuesDisplayed =
    CALCULATETABLE (
        ADDCOLUMNS (
            SUMMARIZE ( 'Cases', 'Cases'[PrimaryTopic2] ),
            "Count", [Primary Topics]
        ),
        ALLSELECTED ()
    )
VAR MinVal =
    MINX ( ValuesDisplayed, [Count] )
VAR MaxVal =
    MAXX ( ValuesDisplayed, [Count] )
VAR CurrentValue = [Primary Topics]
VAR Result =
    SWITCH ( TRUE (), CurrentValue = MinVal, 1, CurrentValue = MaxVal, 2 )
RETURN
    Result

Thanks

[ArchStanton]

I tried your code and got the following error:

[krishnakanth240]

Hi @ArchStanton 

Can you please share the screenshot what exactly you are viewing when you add the above measure into table visual for the tooltip. Can you explain how the output should be.  Thank you!

[ArchStanton]

So the tooltip should show red (Max) and Blue (Min) for the monthly values 
Jan = MIN

Aug Max

As you can see, it works fine in the Matrix but its in the tooltip that I want to be able to see the Max & Min