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

So do you want to ignore filters only for the stores?
For this you can put only those columns in allselected you want to ignore. 

Average Flags:=CALCULATE(AVERAGE(FT_Check[Flags]);ALLSELECTED(FT_Check;FT_Check[Store]))

Std Dev:=CALCULATE(STDEV.P(FT_Check[Flags]);ALLSELECTED(FT_Check;FT_Check[Store]))


let me know if that works. else if you want we can connect @91-9711975011 or [email protected]
Thanks
Deevaker Goel

https://www.linkedin.com/in/deevakerg/

  • GabrielGloria's avatar
    GabrielGloria
    New Member
    3 years ago

    Thanks!!

    But it doesnt work yet.

    i want that my average calculates freezy with all the filters except about the period of time.

    Example:

    Stores of
    Dist 1: ABC, DEF and GHI.
    Dist 2: XYZ, JKL and QWE.

    When I filter July, the average of all stores was 25%.

    I want the tabel shows 25% in this column independent of the district filter at slicer.

    But Thank you so much!!