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

Anonymous
Not applicable

## Sum value with filter and total at the same time

I have two tables one of valor and another one of the month
I want to select the month by a filter and show the value
total of the selected month I got
now that I want to show the total independent value of selecting the month

If I have column year and selected

select Oct /2017

Look This image

I have to a new box with valor all "Mes"

Ano  = Year

Mes = Month

Real Mes = Real Month

I have to = All Month

Ty

2 ACCEPTED SOLUTIONS
Skilled Sharer

Hi @Anonymous,

Try creating a Calculated measure:

Total = calculate( sum( Sales ), filter( all( 'table name' ), 'table name' [year] = 2017))

This should give you your YTD Total, hope this helps.

Regards

Abduvali

Resolver V

Use following measure

`Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )`
2 REPLIES 2
Resolver V

Use following measure

`Total = CALCULATE ( SUM ( yourtable[value] ), ALL( yourtable[month] ) )`
Skilled Sharer

Hi @Anonymous,

Try creating a Calculated measure:

Total = calculate( sum( Sales ), filter( all( 'table name' ), 'table name' [year] = 2017))

This should give you your YTD Total, hope this helps.

Regards

Abduvali

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