Make a variable out of sum value

[Wresen]

Hi and thanks for reading this.

I have a problem that i have problem solving myself.

I have a month and i measure that sums the value for that month.

I would like to be able to add day(nr) to this table and have the "measure" value as it is (179744) for all day(nr) , also i would like the measure to be able to react if slicer is added that would change the totel sum.  see below:

If i add days now it looks like this:

/Thanks

[Anonymous · Accepted solution]

@Wresen I assume your first measure is smoething like this

CALCULATE(SUM('Table'[Value]),ALL('Table'[Month]))
Change it to

CALCULATE(SUM('Table'[Value]),ALL('Table'[Month],'Table'[Day]))

Put the day column as argument in all function

[v-easonf-msft · Accepted solution]

Hi, @Wresen,

Here is a sample I made:

url:

https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/Ebsy0Qis3FdPvM3pHy_l_... 

You can take a  try of  measure like  Measure8

Measure8 = CALCULATE(SUM('Table'[Value] ),ALLEXCEPT('Table','Table'[Month]))

If I  misunderstood your question, please let me know.

Best Regards,

Eason

Community Support Team _ Eason Fang

[Wresen]

Hi v-easonf-msft

Thanks so much for that code , acctully measure 6 and 7 was the one i was looking for .

Really appriciate it.

[Anonymous · Accepted solution]

@Wresen I assume your first measure is smoething like this

CALCULATE(SUM('Table'[Value]),ALL('Table'[Month]))
Change it to

CALCULATE(SUM('Table'[Value]),ALL('Table'[Month],'Table'[Day]))

Put the day column as argument in all function

[Wresen]

Hi vimal_parmar

Thanks so much for your help.

I just needed to do:

CALCULATE(SUM('Table'[Value]),ALL(Table'[Day]))

to get it as i wanted , and i would not have solved it without your help.

/Thanks