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

[dkernen2]

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.  

Thank you in advance!

https://kauffman.box.com/s/3nd49adb9zoivf1gecr7w0e1kiuz1zs6

@MIN

[vinodDrinkPak · Accepted solution]

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

[dkernen2]

This looks like exactly what I need!  Thank you!

[vinodDrinkPak]

@dkernen2 

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

[eliasayyy]

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])

[dkernen2]

@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?

[eliasayyy]

hello what filters do you have on ? 

[dkernen2]

@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 $].

[eliasayyy]

then use 

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

OR

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