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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
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.