Is their a HASONEFILTER option, but checking for multiple filters?

[black_magic1001]

I have a pie chart with 3 categories and aggregated sales for the value of each.

I have a line chart that I want to display the sum of all 3 categories with dates on my axis.

If one value in the pie chart is selected, I want the line chart to show only the sum of that category on the axis.

Here is the tricky part... if 2 or more categories are selected on the pie chart, I need to display each category as a separate line on the line chart. NOT an aggregate.

I am thinking that the best way to do this is to simply have 2 line charts overlapping and utilize a function like:

IF ( ISFILTERED(table[column]),[Sum of Category], BLANK())

Or maybe use HASONEFILTER()?

Basically, I am wondering how I can check to see if 2 or more filters are applied to the line chart and if so, hide one line chart and simply display a normal line chart in its' place.

[amitchandak]

@black_magic1001 , One of the ways, I can think of is having category as the legend in line visual. Only thing is that, when nothing is selected , you will see all category

[black_magic1001]

Category is the legend.

I am trying to hide the chart if there are more than 2 categories selected.  Instead of HASONEFILTER() function I need a function like "HasTwoOrMoreFilters()".

[black_magic1001]

UPDATE:

Attempt 3 test = IF(HASONEFILTER(ContractPurchases[PackageID]) || ISFILTERED(ContractPurchases[PackageID]) = False,[sumTEST], BLANK())

Attempt 4 test = IF(HASONEFILTER(ContractPurchases[PackageID]) = FALSE && ISFILTERED(ContractPurchases[PackageID]) = TRUE,[sumTEST], BLANK())

This is where I am currently, but in Attempt 4 Test I need to show multiple lines.  Right now I am displaying a single sum.

[amitchandak]

@black_magic1001 , You can simply do a count

if(count(ContractPurchases[PackageID]) >=2, blank(),[sumTEST])

[black_magic1001]

Ok but that still does not answer the question of how to show multiple lines on the graph when 2 or more filters are chosen. [sumTEST] is just the sum of the column I want to see.