Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
In a powerPivot table. "CompletContratrem"
I have a "Brut" column, decimal number format.
And a measure "fx_Brut":=Sum([Brut])
and another "Année" column, Text format
example
nom | Brut | Année | |
Titi | 1125,45 | 2020 | |
Toto | 3456,87 | 2021 | |
Tata | 3456,21 | 2020 | |
tete | 1765,12 | 2021 |
I would like the "Brut" total if "Année" = 2020,
I tried several solutions, but it stuck
I have already calculated a measure to get 2020 (the smallest year in the Year column)
Regul_N_1:=calculate(value(max(CompletContratrem[Année]))-1)
i get good 2020
But,
even though I converted the "Année" column to integer, the metric "fx_Brut_N_1"
fx_Brut_N_1:=calculate([fx_Brut];filter(CompletContratrem;CompletContratrem[Année] =[Regul_N_1]))
, returns me (empty)
If I leave the Year column as text, and I adapt the measure by converting Année with Value
fx_Brut_N_1:=calculate([fx_Brut];filter(CompletContratrem;Value(CompletContratrem[Année] )=[Regul_N_1]))
, I also have a value return (empty)
On the other hand, if I modify the measure and set a hard comparison criterion ex: 2020, it works.
fx_Brut_N_1:=calculate([fx_Brut];filter(CompletContratrem;Value(CompletContratrem[Année] )=2020))
, returns the correct value
but,
fx_Brut_N_1:=calculate([fx_Brut];filter(CompletContratrem;Value(CompletContratrem[Année] )=value([Regul_N_1])))
Always returns (empty)
I don't understand, I need explanations and help.
Thank for your help
Philippe
Solved! Go to Solution.
Thank a lot,
i will read the article on context transition that i don't know.
philippe