selectedvalues in Excel PowerPivot

[nicolast29]

https://1drv.ms/u/s!AoqtZHsX4Bzvg_gO4DA7tR5F5XABhw?e=GEeEAy 

Hi

I have made a calculated column a table (Balance) in order to recover a information from another table in my bi report, it work great ...

catégorie PCG = 
Var Compte_Pcg ='Balance'[Compte]
Var fouchette_correspondante =FILTER(fourchettes, Compte_Pcg>=fourchettes[Début] && Compte_Pcg <= fourchettes[Fin])
return
CALCULATE(SELECTEDVALUE(fourchettes[Catégorie]),fouchette_correspondante)

but at the end the user wanted it only in Excel, so I try to transform it but selectedvalues is missing

I have made a lot of try with for example with  IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ) ), but it always ended with error

There is something that i does missandertand i think

I put in attached file the pbix (cc.pbix) and the Excel file (cc.xlsb)

Thanks a lot for helping

[amitchandak · Accepted solution]

@nicolast29 , You need to some expression to return one value there like max , try

catégorie PCG =
Var Compte_Pcg ='Balance'[Compte]
Var fouchette_correspondante =FILTER(fourchettes, Compte_Pcg>=fourchettes[Début] && Compte_Pcg <= fourchettes[Fin])
return
CALCULATE(max(fourchettes[Catégorie]),fouchette_correspondante)

[nicolast29]

thanks a lot

It works

If i understant, whitout the max it return a table who is a problem, but with the max it return a single value and that it ?