Calculate with Slicer

[Anonymous]

Hello

I have a table that calculate sum of sales by month, for example:

my goal is that when i choose month in the slicer, i want to see 0 or blank in those month's i didnt choose.

as you can see, I sliced the table by months 1,2,3, the total is good (blue column) but i see the values in the other months.

I calculate the month by :
1= calculate(sum(sales),month=1) and so on.

I cant use matrix, only table.

Thanks.

[Anonymous · Accepted solution]

I figure it out with this measure:

Thank you !

[lucadelicio]

Hi Bidev,

can you upload the pbix file in wetransfer.com?

I will help you!

Thank you,

[Anonymous]

I cant upload the original one but i created a test file.

https://filebin.net/y9s5e34i4odxs4m4

thanks