Minimum value subtotal based on specific dates

Hi, I'm trying to add subtotal with the minimum value and the subtotal is also taking a minimum of the total price. If I want to apply value as a minimum and sum up them into the subtotal, what ...

Need Help

Jihwan_Kim
5 years ago
Hi, sunah132
Thank you for sharing.
Please try the below.

Min Value measure =
SWITCH (
TRUE (),
ISINSCOPE ( 'Table'[item] ), SUMX ( VALUES ( 'Table'[Date] ), MIN ( 'Table'[Value] ) ),
SUM ( 'Table'[Value] )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM

sunah132

Helper I

5 years ago

Thank you! I have one last question regarding the Matrix calculation. When there's drill down like this, adding Calculate at SUMX would sum up the entire Hub but not in route level. I have tried adding SUM('Table'[Value]) as route but the visual failed to do so.