Line value disappears in Combo Chart

[AnnaML]

Hello, 

I'm currently working on a combo chart visualising hours worked per department, actuals vs target. Hours is called HpT. I only want to show one department by default when opening the report and than be able to filter on another department. 

I created the following to be able to get one of the department as default (29221 is the department): 

FA1 Dep Actuals =

IF(COUNTROWS(DISTINCT(ALLSELECTED(Weekly[Department]))) < COUNTROWS(DISTINCT(ALL(Weekly[Department]))) , CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Actual" })

,

IF(SELECTEDVALUE(Weekly[Department]) = "29221",CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Actual" }) ))

I created the same for Target as well: 

FA1 Dep Target =

IF(COUNTROWS(DISTINCT(ALLSELECTED(Weekly[Department]))) < COUNTROWS(DISTINCT(ALL(Weekly[Department]))) , CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" })

,

IF(SELECTEDVALUE(Weekly[Department]) = "29221",CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" }) ))

When adding these two to a combo chart the target line disappears. Does anyone know what the issue can be? 

I can see the hours for both actuals and targets by week if I add the created fields to a table. But as soon as I change the visualization to a combo shart the target line disappears (see picture below)

As you can see in the picture, the actuals for department 29221 is showing but the line for target is not showing. 

Thankful for support, 

[amitchandak]

@AnnaML , Try like

FA1 Dep Target =
IF(COUNTROWS(DISTINCT(ALLSELECTED(Weekly[Department]))) < COUNTROWS(DISTINCT(ALL(Weekly[Department]))) , CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" })
,
IF(countx(filter(allselected(Weekly) ,Weekly[Department] = "29221"),Weekly[Department) <> blank(),CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" }) ))

[AnnaML]

Thanks for your answere. I tried and got the following:

Now I get the target line but for all departments and not just department "29221". Do you know what might be the problem? 

Thanks in advance 

[v-kelly-msft]

Hi @AnnaML ,

FA1 Dep Target =
IF(COUNTROWS(DISTINCT(ALLSELECTED(Weekly[Department]))) < COUNTROWS(DISTINCT(ALL(Weekly[Department]))) , CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" })
,
IF(SELECTEDVALUE(Weekly[Department])= "29221"),CALCULATE(SUM('Weekly'[HpT]), 'Weekly'[Scenario] IN { "Target" }) ))

 If the measure still doesnt work,would you pls provide some sample data with expected output?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!