A function 'SELECTEDVALUE' has been used in a True/False expression that is used as a table filter

[bhelou]

Dear Please if anyone can help me with this measure :

Population =

VAR

Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))

Return

CALCULATE([Pop Total Estimates running total in Year],SELECTEDVALUE('Capitals Unique'[Country]))
@amitchandak  ( thank you for usual help)

// The selected value country is a slicer , once i need to select from it i need the population result 

Many Thanks ,

[amitchandak · Accepted solution]

@bhelou , Use filter

Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] = SELECTEDVALUE('Capitals Unique'[Country])))

If these tables are joined, no need to add this clause

for more than one value

Population =
VAR
Population = CALCULATE(SUM(ESTIMATES[Pop Total Estimates]))
Return
CALCULATE([Pop Total Estimates running total in Year],filter('Capitals Unique', 'Capitals Unique'[Country] in  allselected('Capitals Unique'[Country])))

[bhelou]

Thank you @amitchandak  worked verry good , like always many thanksss