Solved: Power BI measure ? Min Sum Values here to get a t...

Milestone · ‎07-18-2022

amitchandak · ‎07-18-2022

Sumx(Values(Table[Week Of]) , Calculate(<Your calculation on Min Debit and credit>) )

example

Sumx(Values(Table[Week Of]) , Calculate(Min([Debit], [Credit] ) ) )

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎07-18-2022

@Milestone , Try like

Sumx(Values(Table[Week Of]) , Calculate(<Your calculation on Min Debit and credit>) )

example

Sumx(Values(Table[Week Of]) , Calculate(Min([Debit], [Credit] ) ) )

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Milestone · ‎07-18-2022

You are amazing. Thank you so much. You totally rocked it on helping me. Forever grateful :)))))))))

Power BI measure ? Min Sum Values here to get a true sum total result from the measure.

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

How to Get Your Question Answered Quickly

Be one of the first to start using Fabric Databases.