Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    2 years ago

    I figure it out with this measure:

    Thank you !

3 Replies

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual

    Hi Bidev,

    can you upload the pbix file in wetransfer.com?

    I will help you!

    Thank you,

  • Anonymous's avatar
    Anonymous
    Not applicable

    I figure it out with this measure:

    Thank you !