Total sum get result grouped by other columns

[thomas682]

Hello community,

i try to understand the calculation of a total sum.

I created a new measure to add all hours on days ("Ist-Aufwand"):

Total =
var x1 = CALCULATE(SUM(Stunden[Ist-Aufwand]);Filter(ALL(Stunden[Datum]); Stunden[Datum] <= MAX(Stunden[Datum])))
return
x1

the table looks like:

with this result:

The total is not a total overall ??

Can i avoid that the total calculation depends from other columns or be grouped?

thanks for help

thomas 

[camargos88]

Hi @thomas682 ,

Try this:

Total = CALCULATE(SUM(Stunden[Ist-Aufwand]);Filter(ALL(Stunden); Stunden[Datum] <= MAX(Stunden[Datum])))

[thomas682]

thanks for your help, but I should to explain want I want:

I have a list of projects with hours working time for every day.

I then filter all projects that I want to evaluate with a BI Filterbox.

In this example You see only the projects with the number "088103" and "088102". 

(I often use an addional date filter to limit the analyzing)

As result the total counts each project separately (starts from 1) , but I want the total for all projects without grouped calculation!

e.g.

   

...the red column is what I want.

Hope I could explain it better understandable

thomas

[thomas682 · Accepted solution]

I find a solution

I have changed the measure:

CALCULATE(SUM(Stunden[Ist-Aufwand]);Filter(ALL(Stunden[Datum]); Stunden[Datum] <= MAX(Stunden[Datum])))

to

CALCULATE(SUM(Stunden[Ist-Aufwand]);Filter(ALLSELECTED(Stunden); Stunden[Datum] <= MAX(Stunden[Datum])))

and now the total count over all!

thanks for your suggestions,

thomas

[amitchandak]

@thomas682 , Try like

Total =
var x1 = CALCULATE(SUM(Stunden[Ist-Aufwand]);Filter(ALL(Stunden[ProjectNum]); Stunden[ProjectNum] <= MAX(Stunden[ProjectNum])))
return
x1