cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I

## Needing a DAX Measure for the Minimum Value of All the Category Totals

I need to create a measure that shows the the value of the smallest category total.  I have included a small dataset, but here is a text version of what I need:

 Department Paid \$ (Measure that sums the paid amounts) Blue -25 Green 40 Purple 24 Red 74

I need a measure that shows the minimum departmental [Paid \$], in this case -25.  I need the measure to use any other filters already on the report.  I'm stumped.

@MIN

1 ACCEPTED SOLUTION
Helper II

Minimum Paid \$ =
MINX(
ALL('YourTableName'[Department]),
[Paid \$]
)

8 REPLIES 8
Helper II

Minimum Paid \$ =
MINX(
ALL('YourTableName'[Department]),
[Paid \$]
)

Helper I

This looks like exactly what I need!  Thank you!

Helper II

thank you, please accept this as solution, so that others can also take the benefit

Super User

if you have filters you need to keep just swap all with allexcept and fill the slicers you need

``````Min = CALCULATE(MIN('Table'[Paid]),ALL('Table'))

OR

min = MINX(ALL('Table'),'Table'[Paid])``````

Helper I

@eliasayyy Thank you for your swift reply.  This is finding the minimum value of the column, not the minimum value of the measure.  How can I find the minimum measure total?

Super User

hello what filters do you have on ?

Helper I

@eliasayyy I could have other filters on such as Person or Region, as an example.  I just want the measure to respect other filters if they are present.  I need it to calculate the [Paid \$] measure first by department, and then return to me the smallest category aggregation [Paid \$].

Super User

then use

``````min = CALCULATE(MIN('Table'[Paid]), ALLEXCEPT('Table',[Region],[person]))

OR

min = MINX(ALLEXCEPT('Table',[Region],[person]),'Table'[Paid])``````