Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Finding a minimum value with a filter application

I am trying to write a measure that finds me the lowest value from a specific set of locations, I am having trouble with how to include a filter in my expression. For example, I have a table with 50 ...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, Anonymous ;

    I am not very sure whether understand your table structure correctly. and base on my understand ,i create a simple example as follows:

    1.enter table as a fiter(slicer)

    2.create a measure .

    min = IF(MAX([Group])="locations  1",MIN(Table1[values]),IF(MAX([Group])="locations  2",MIN(Table2[values])))

    The final output is shown below:

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

it's always helpful if you give an example how your data looks like. Now I can just guess.

If you want to get the minimum from 2 different tables you can use the MIN function:

Min Location = MIN( Table1[LocationColumn], Table2[LocationColumn] )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the quick response. Perhaps I did not explain my question fully.

     

    Lets say I have one master table that contains a column with 50 restaurant locations, and a column with 200 values that show profit  for last year (4 entries per location, with 1 value each quarter). I have one table in my actual working page that contains half of the locations (based on size) and 100 entries. If I do a MIN function for just these 25 locations, the smaller locations still show up. I want to perform a MIN function along with the filter I used to separete the locations. Thanks