Forum Discussion

nicolast29's avatar
nicolast29
Helper V
4 years ago
Solved

selectedvalues 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...
Excel
powerpivot
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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's avatar
    nicolast29
    Helper V
    4 years ago

    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 ?