Forum Discussion
nicolast29
Helper V
Helper Vselectedvalues in Excel PowerPivot
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 gr...
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)
amitchandak
Super User
Super Usernicolast29 , 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)