Forum Discussion

kavitabehera's avatar
kavitabehera
Advocate II
3 years ago
Solved

Calculated minimum value by multiple categories

I wanted to create a calculated table that fetches the minimum value by 2 text columns.   For example: Let's take this below example, the question is to bring the minimum sale for the region by cat...
  • v-jialluo-msft's avatar
    v-jialluo-msft
    3 years ago

    Hi kavitabehera ,

     

    I think it is just necessary to add another calculation table on top of the example file
    (1)     Add a calculation table

    Table 2 = SUMMARIZE (
    'Table', 'Table'[Region],
    "MIN",MIN('Table'[MinXSale])
)

    (2)Final output

     

     

    Best Regards,

    Gallen Luo

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jialluo-msft's avatar
v-jialluo-msft
Community Support
3 years ago

Hi kavitabehera ,

 

Please follow these steps:

(1) Create a new calculated table

Table 2 = 
SUMMARIZE ( 'Table', 'Table'[Region], "Min", MIN ( 'Table'[Total Sale] ) )

(2) Final output

 

 

According to known data, the minimum value of EAST should be 29870.36,.

if the above resulte is not what you need or I do not understand your need, please indicate the correct approach or provide specific data

 

Best Regards,

Gallen Luo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kavitabehera's avatar
kavitabehera
Advocate II
3 years ago

Thank you for replying.

 

In your case, it worked because we don't have any other columns except these three. But let's assume we have one more column "colors" due to which the minimum value will affect.

 

Currently, with this measure, I can summarize region and category by min sales by segment. Here is the snapshot

Table = SUMMARIZECOLUMNS ( Orders[Region], Orders[Category], "MinXSale", MINX ( VALUES ( Orders[Segment] ), [Total Sale] ) ) --Minimum Sale by Segment 

 

 

But the answer I am looking for is 

Central25482

East

29870West33638South16853

 

 

Here is the dataset link that will help you recreate the situation.

https://drive.google.com/file/d/1xGwidMFLevCFmp9OQHjSvlj-skPZEATn/view?usp=sharing