Conditional formatting in Filled Map with slicers, measure as a tooltip

[Anonymous]

Hey there. This one's got me scratching my head for a few days now but I'm still not able to make headways . .

I have created a filled map (color map) with conditional formatting to render different counties in the USA in different colors. The conditional formatting depends on a measure I created, which calculates the percentage of cases won for each county. If the percentage is above 70 then render it green, if it's below 50 then render it red and so on. Below is the definition of the measure :

Win % by County =

DIVIDE(

CALCULATE(

COUNT('Win % by County'[Win_Flag]), FILTER('Win % by County', 'Win % by County'[Win_Flag] = "Y"))

, [Number of XX], 0)

"Number of XX" is another measure which is being used inside this measure. I also have a couple of slicers

for date and another category, which filters the number of datapoints based on selection. What I expected to happen

was that when I make selection in the slicer(s), the number of datapoints would change in the context and

consequently the colors in which the counties rendered would change. However, that does not seem to happen.

Also, I am using both of the above mentioned measures in the tooltip well. However, whenever I slice the data

, on some datapoints PBI shows only one tooltip info. and the other one vanishes. At the same time, some datapoints

show both tooltip fields when hovered over.

Any help is appreciated guys. This one is really taking up so much of my time. Is there something obvious that I am missing ?

Sorry I couldn't post anything other than the description of problem I'm facing. Confidentiality issues and all . .

Thanks in advance.

[v-lili6-msft]

hi  @Anonymous 

You may need to add ALL function in [Number of XX], see more details as below:

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

and if not your case, please share a simple sample pbix file, that will be great help.

Regards,

Lin

[VijayP]

@Anonymous 

Require at least some piece of information. at least in an excel with some dummy data with a note what is needed helps to you answer your question. please share your Kudoes