Bar chart with a fixed bar along with filter selections

[sthomas38]

Hello,

        I am trying to compare few networks to a specific network. So, I want one of those networks to always be there no matter what other selections are made. Here are the details -

I have a multi-selection filter called Networks with the options - Aetna, Cigna, Guardian, Humana, UHC etc.

I have a bar chart that shows the unique providers for these networks (one bar per network).

I want to set it up, such that Humana's unique provider count is always shown - no matter what filters are chosen.

Example: If filter is chosen to show all networks - then all are shown

If filter is chosen to show only Aetna, then Aetna and Humana is shown.

If filter is chosen to show Aetna and Cigna, then Aetna, Cigna and Humana is shown. 

If nothing is chosen, then Humana is shown. 

I have no clue how to go about it. Any help is appreciated. Thank you for your time. 

[samdthompson]

hello, might be better to show on a line/column chart with humana as the line. thatway you can easily see the above or below the line performance. The bars will then colour themselves based on the network name.

[sthomas38]

Hi Thank you so much for the quick response.

So I do have a measure - Value_Count = DISTINCTCOUNTNOBLANK(NETWORK360_COMPETITOR_PIVOT[Value])

Can you check the formula please? I am getting an error when I use "All". 

Where do I place this?

[samdthompson · Accepted solution]

Oh sorry, my bad, i missed the closing bracket around the all. It should be

=calculate([value], filter(all(network360_competitor),network360_competitor[attribute]="Humana")

[sthomas38]

Thank you so much! I see Humana now.. even if I select or unselect the filters... but is there a better way to show this? Right now, it looks like this - 

Is there anyway to show it in this format? 

[samdthompson]

Hello, not quite sure what you structure looks like but assume you have some existing measure then you will want a Humana measure to add in. something like:

ValueMeasure=SUM(Table1[Value])

HumanaValueMeasure = CALCULATE([ValueMeasure],FILTER(All[Table1],Table1[ProviderName]="Humana"))