Tooltip Reports - Is there a way to apply two filters to the same card? State vs Region data on Map

[Anonymous]

Hi All,

I have a Tooltip Report for a US map. I want to show data for the state, as well as the overall region data. Right now, only one filter is being applied.

Is there a way to distinguish the state and region data?

Thanks for any information!

[parry2k]

@Anonymous you can surely achieve this by creating new measure for Region which ignores the State filter. If you can share sample data, I can get you a measure to achieve this.

[Anonymous]

Hey @parry2k,

I was working on this more today. This measure does *almost* I want to achieve

Region_Count = CALCULATE(DISTINCTCOUNT('BID FILE'[PROBILL]),ALLEXCEPT('BID FILE','BID FILE'[Destination State Regions],'BID FILE'[CONSIGNEECOMPANY_CLEAN]))

I issue I run into with it is that while it does calculate the regional data, it only shows the total for the "customers" in the state I'm hovering over.

For example, say I have a list of 10 customers with regional data. If say a state's top customers are Customer 2, Customer 6, Customer 10, then the regional data will only show those customers. The data is correct; I just want the top in that region, no matter the customer in the state.

I appreciate your help on this!

[Anonymous]

Hi, @parry2k . Thanks for replying!

This is a rough idea of the data.

I want the count of unique IDs by category. So, if I hover over Pennsylvania, I will see:

Pennsylvania

Category 1 (2)

Category 2 (2)

Region

Category 1 (3)

Category 2 (3)

State	Region	Category	ID
Pennsylvania	Northeast	Category 1	1236
Pennsylvania	Northeast	Category 1	1547
Pennsylvania	Northeast	Category 2	8456
Pennsylvania	Northeast	Category 2	9874
New York	Northeast	Category 1	7412
New York	Northeast	Category 2	8521