select all in slicer visual

[Anonymous]

Hi everyone,

i have a slicer (List) with different countries like India,Uk,USA,Germany,France,etc. I have enable "show all" option  in selection control. if select Select All then i must get sumof column A and column B. if i select single country then i must get sum of column A  only. can we achive this in power bi

[Anonymous]

@amitchandak Thanks for this it worked 

[amitchandak · Accepted solution]

@Anonymous , using isfiltered

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

if(isfiltered(Table[country]), sum(Table[A]) , sum(Table[A]) +sum(Table[B]))