Total Sum

[sprao]

Hi All,

Sorry everyone...May be for you all its basic question, but i just stareted learning i need your help..

How to sumup sales for last selection in filter,(Ex:ABC21)

here i want show when i select Year:ABC21 need my result in graph 175.Thank you all

Thank you all

[Anonymous · Accepted solution]

Hi @sprao ,

Use below steps to achieve this,

Measure:

SUM_Sales = IF(SELECTEDVALUE('Table'[Year])="ABC1",CALCULATE(SUM('Sample'[Sales]),ALL('Sample'[Year])),CALCULATE(SUM('Sample'[Sales]),USERELATIONSHIP('Sample'[Year],'Table'[Year])))

Inactive Relation:

ABC1:

For 2020:

Best Regards,

Mail2inba4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sprao]

its not working for me..i given below DAX formula..

[sprao]

Really sorry my above reply your solution worked.. i forgot to inactive relation between tables in above post...

[Anonymous]

@sprao  - There are several options here, each with drawbacks:

1. UNION a row into the table for the total - this will be problematic, because the Total will be doubled when unfiltered.
2. Simply consider the lack of a filter (Grand Total) to be the value you're looking for. However, if the category only covers a certain subset of years, this won't work properly.
3. If #2 doesn't work, try creating a separate column for the Year Category. Then use the new column as a filter instead of the years.

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.