Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
5 years ago
Solved

Hard time figuring out context

Hello all, Hard time to get the result expected.  Every variable has been checked but the problem seem to be the context of "Base" in SUMX:   The result expected is the value of Covar...
Need Help
  • Fcoatis's avatar
    Fcoatis
    5 years ago

    Here is what I ended up.

     

    .Covar = 
VAR Tabela =
    FILTER(
        SELECTCOLUMNS(
            ALLSELECTED(Base[Date]),
            "LnAsset",  [.ln],
            "LnIBOV", CALCULATE([.ln],Base[Asset]="IBOV")
        ),
        AND (
            NOT( ISBLANK( [LnAsset])),
            NOT ( ISBLANK( [LnIBOV] ))
        )
    ) 
VAR Denom = COUNTROWS(Tabela)-1
VAR Res = SUMX(Tabela, ([LnAsset]-AVERAGEX(Tabela,[LnAsset]))*([LnIBOV]-AVERAGEX(Tabela,[LnIBOV]))/Denom)
RETURN
Res
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Fcoatis I'm not understanding your use of SUMX here. Result being a variable will always be the same value so I do not believe SUMX(Base,Result) should be any different than just Result. Perhaps you meant to create a table variable and use ADDCOLUMS with the Result calculation as a column in the table and then SUMX across it?

  • Fcoatis's avatar
    Fcoatis
    Icon for Post Patron rankPost Patron
    5 years ago

    Greg_Deckler thanks for your answer. I just wanted to add all the values of Result. When I just called Var Result it didnt show the expected value ( -0.0000795701 ). I´m missing the table variable. Just fyi the SUMX(Base, Result) and just Result returned diferent values. I can share the pbix if you like. Thanks again.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Fcoatis PBIX would definitely help.