cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Using sum & min in Dax queries

Hi All,

Does anyone know how I can sum the lowest value for each category?

I understand we can use the min formula. However, it also gives me the minimum value of all categories in the grand total.

For example, If I use min(Project Name), the grand total in a table shows a grand total of 1 but will accurately show A = 1, B = 2, C = 3. What I need is a grand total of 6 (1+2+3).

This is what my data set looks like

 Project Value A 1 A 10 B 2 B 20 C 3 C 30

What I want to achieve as a table in Power BI

 Project Value A 1 B 2 C 3 Total 6

Any helps is appreciated.

Cheers,

Kev

1 ACCEPTED SOLUTION
Anonymous
Not applicable

You have to sum the minima over projects. Something like:

``````sumx(
// would be better to run over ProjectID;
// iterate over something that is unique
// to the projects
distinct( T[Project Name] ),
calculate(
min( T[Value] )
)
)``````

Anonymous
Not applicable

You have to sum the minima over projects. Something like:

``````sumx(
// would be better to run over ProjectID;
// iterate over something that is unique
// to the projects
distinct( T[Project Name] ),
calculate(
min( T[Value] )
)
)``````

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors