Forum Discussion
Anonymous
2 years agoNot applicable
Calculate with Slicer
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.
- Anonymous2 years ago
I figure it out with this measure:
Thank you !
3 Replies
- lucadelicio
Impactful Individual
Hi Bidev,
can you upload the pbix file in wetransfer.com?
I will help you!
Thank you,- AnonymousNot applicable
I cant upload the original one but i created a test file.
https://filebin.net/y9s5e34i4odxs4m4
thanks
- AnonymousNot applicable
I figure it out with this measure:
Thank you !