Want to calculate total net sales based on country and financial year.

[jay_patel]

Hello All,

I want a dax to get total net sales based on country and fin-year only, it should not filter rest columns of the same table.i have a below dataset:

Country	Marketing product	Product Code	Fin Year	Net Sales	Required column-Total Net Sales
Kenya	abc	223	23-24	200	300
Kenya	ade	35	23-24	100	300
Kenya	dfg	56	22-23	50	50
Greece	sdf	67	23-24	50	110
Greece	fgh	89	23-24	60	110
Greece	ert	65	22-23	70	150
Greece	jhg	44	22-23	80	150

the required measure or dax should give result as mentioned in Required column-Total net Sales. note, there are many other columns in the same table but it should not filter those columns except Country and fin-year.

Thanks in advance

[PijushRoy · Accepted solution]

Hi @jay_patel 

Please try to use below DAX in measure

Measure = 
CALCULATE(
    SUM('Table'[Net Sales]),
    ALLEXCEPT('Table','Table'[Country],'Table'[Fin Year]))

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin