View - Show Total by Category

[Anonymous]

Hi all.

I have a table with a filter, this table show me values and a graph

Everythig is fine except fot the graph

It is not showing the total month-to-month

Month on Axis, ACUMULADO and COMPROMETIDO for values, however ACUMULADO and COMPROMETIDO are a measures as I could solve this?

[Anonymous · Accepted solution]

ACUMULADO = SUM(tb2[Value]) of all month and years

COMPROMETIDO = SUM(tb1[Value]) of all month and years

I do not know how to post the file here  =/

Ty

[Greg_Deckler · Accepted solution]

Generally, load the file up on OneDrive or Box or Google, share it and paste the link to it.

[Greg_Deckler]

Would have to see some data and your formuals for your measures

[Anonymous · Accepted solution]

ACUMULADO = SUM(tb2[Value]) of all month and years

COMPROMETIDO = SUM(tb1[Value]) of all month and years

I do not know how to post the file here  =/

Ty

[Greg_Deckler · Accepted solution]

Generally, load the file up on OneDrive or Box or Google, share it and paste the link to it.

[Anonymous · Accepted solution]

Sorry =/

In my measure measure = calculate(sum(value); all(month))

Remove All(Month) and It Worked

Ty for the attention