Filled Map: Why is only one Business in the tooltip when 8 are recorded?

[raccooncity]

Morning all,

I have a filled map drill down from Region, Country, then Business. Although when I select a Country, India for example, the tooltip indicates that 1 Business is in the Country when there are actually 8?

Does anyone have any suggestions on how to resolve this?

I've attempted to make a custom tooltip but the outcome is the same.

Thanks in advance!

[Anonymous]

Hi @raccooncity ,

Please create a measure using CONCATENATEX that concatenates all the businesses for a country and plot the measure in the Tooltips.

You can refer to the similar post that may be helpful to you:

Filled map shows incorrect numbers in tooltip - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.