Forum Discussion

MiloPowerBI's avatar
MiloPowerBI
Frequent Visitor
3 years ago
Solved

Adding a MIN Filter/Function to Weekly Sales Data

Hello all,    Hoping someone can help me with a little tweak to a measure.    I'm trying to teach myself some DAX and I'm playing with a very small, limited data set. See below. I have other Prod...
Need Help
Tips and Tricks
Tutorial Requests
  • Wilson_'s avatar
    Wilson_
    3 years ago

    Hi Milo,

     

    By using ALL in your FILTER function, you are ignoring all filter contexts applied to the whole data table. It sounds like you are looking for ALLSELECTED instead.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Wilson_'s avatar
Wilson_
Memorable Member
3 years ago

Hi Milo,

 

By using ALL in your FILTER function, you are ignoring all filter contexts applied to the whole data table. It sounds like you are looking for ALLSELECTED instead.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)