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 ,

 

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.