Forum Discussion

GabrielGloria's avatar
GabrielGloria
New Member
3 years ago

ALL SELECTED,

Hello, everyone! Im beggining with DAX languages, power BI, Power Pivot and etc. Im using dax in a excel Pivot analysis and im with problemas with context filters. This is my Data of one pro...
Need Help
deevaker's avatar
deevaker
Resolver I
3 years ago

You can try allexcept() function where just put those column name that should not be ignored from filter like your external columns and/or begin date

  • GabrielGloria's avatar
    GabrielGloria
    New Member
    3 years ago

    Hi Deevaker!

    Have i put ALLEXCEPT like a "filter2" in Calculate?

    I ve tried these:

    Average Flags:=CALCULATE(AVERAGE(FT_Check[Flags]);ALLEXCEPT(FT_Check;FT_Check[Begin Date]))

    Std Dev:=CALCULATE(STDEV.P(FT_Check[Flags]);ALLEXCEPT(FT_Check;FT_Check[Begin Date]))

    But it doesnt work, because the average and std dev, use all the database, independent of the filters: