Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
dkernen2
Helper I
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:

 

DepartmentPaid $ (Measure that sums the paid amounts)
Blue-25
Green40
Purple24
Red74

 

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

 

1 ACCEPTED SOLUTION
vinodDrinkPak
Helper II
Helper II

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

View solution in original post

8 REPLIES 8
vinodDrinkPak
Helper II
Helper II

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

This looks like exactly what I need!  Thank you!

@dkernen2 

 

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

eliasayyy
Super User
Super User

annonymous1999_0-1694180722502.png


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

 

 

@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
Super User
Super User

hello what filters do you have on ? 


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

then use 

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

OR

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.