can I calculate grand total applying visual filters?

[Anonymous]

Hello guys 🙂

That's my "model"

my calculated column "a_ClientTotal" is:

a_ClientTotal = CALCULATE(sum(Dados[Value]),ALL('Dados'),filter(Dados,Dados[Client] = EARLIER(Dados[Client])))

I'm trying to change my Date filter and my calculated column keep the value.

What I missing in my dax calculated column?

Tks.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You want the returned values by a_ClientTotal can be dynamically changed depend on date slicer range, right?

If so, you should create a measure like below rather than a calculated column, as calculated column values are initialized since it is created.

a_ClientTotal = CALCULATE( sum(Dados[Value]),ALLSELECTED(Dados[Date]))

Below is the result in my test.

Best regards,

Yuliana Gu

[Ashish_Mathur]

Hi @Anonymous,

Sorry, i am not clear.  What result are you expecting?

[Meirieli]

Hi, @Anonymous,

You can follow the steps bellow:

1 - Create a measure called Total Value:

Total Value = SUM(Dados[Value])

2 - Create a measure Called b_ClientTotal:

b_ClientTotal = CALCULATE([Value],ALLEXCEPT(Dados,Dados[Client],Dados[Date]))

That´s all Folks