Show different data on plot based on slicer selection

[bsas]

Hi PBI Experts,

I need your expertise whether I can show different data (line on the plot) based on slicer selection. I have slicer by territory: "North America or Europe or both". I need to show fact% for each territory if it is selected but I need to show totalFact% if both are selected. TotalFact% <> fact%. Can I somehowe show different value in case where both territories are selected?

Example of my table and data below.

Territory	MonthShort	Month	Fact %	TotalFact%
North America	Jan	Sunday, January 1, 2017	-1.2308	-3.2801
North America	Feb	Wednesday, February 1, 2017	0.5228	0.1904
North America	Mar	Wednesday, March 1, 2017	0.5057	0.4356
North America	Apr	Saturday, April 1, 2017	0.5228	0.546
North America	May	Monday, May 1, 2017	0.6213	0.7022
North America	Jun	Thursday, June 1, 2017	0.5259	0.5235
North America	Jul	Saturday, July 1, 2017	0.5228	0.8157
North America	Aug	Tuesday, August 1, 2017	0.3706	0.2724
North America	Sep	Friday, September 1, 2017	0	0
North America	Oct	Sunday, October 1, 2017	0	0
North America	Nov	Wednesday, November 1, 2017	0	0
North America	Dec	Friday, December 1, 2017	0	0
Europe	Jan	Sunday, January 1, 2017	0	-3.2801
Europe	Feb	Wednesday, February 1, 2017	0	0.1904
Europe	Mar	Wednesday, March 1, 2017	0	0.4356
Europe	Apr	Saturday, April 1, 2017	-0.0949	0.546
Europe	May	Monday, May 1, 2017	0.485	0.7022
Europe	Jun	Thursday, June 1, 2017	0.675	0.5235
Europe	Jul	Saturday, July 1, 2017	0.7969	0.8157
Europe	Aug	Tuesday, August 1, 2017	0.2724	0.2724
Europe	Sep	Friday, September 1, 2017	0	0
Europe	Oct	Sunday, October 1, 2017	0	0
Europe	Nov	Wednesday, November 1, 2017	0	0
Europe	Dec	Friday, December 1, 2017	0	0

[v-jiascu-msft · Accepted solution]

Hi @bsas,

How does your report look like? You could try to use a measure of TotalFact% instead.

1. If you don't care the initial status, you can try this:

Measure =
IF ( HASONEVALUE ( Table1[Territory] ), BLANK (), SUM ( Table1[TotalFact%] ) )

2. If you want to hide the TotalFact% in the start, you could try this:

Measure 3 =
IF (
    ISFILTERED ( Table1[Territory] )
        && DISTINCTCOUNT ( Table1[Territory] ) = 2,
    SUM ( Table1[TotalFact%] ),
    BLANK ()
)

Best Regards!

Dale

[bsas]

Thanks @v-jiascu-msft,  2nd measure is great, I've changed it a little and created one more based on it. 

[v-jiascu-msft]

Hi @bsas,

It's my pleasure.

Best Regards!

Dale