Forum Discussion

GabeCass's avatar
GabeCass
Regular Visitor
2 years ago

Maintain all matrix rows and columns

Hi all,

 

I'm struggling with the following issue:

 

I have a matrix displaying sales by product category in different year columns: 

 

 

Also, I have a slicer with months (calendar table with a relationship on Sales' date table):

 

 

 

My goal is to maintain the matrix structure (display all columns and rows, even with no data) if I select one single month or a period in my slicer.

 

I noticed that in this case simply selecting 'show items without data' in the product field does not solve the problem.

 

Does any one know to do I do that? 

 

Thanks in advance!

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • sayaliredij's avatar
    sayaliredij
    Icon for Solution Sage rankSolution Sage
    2 years ago

    hi GabeCass 

     

    You can write your sales measure in following way

     

    Sales Amount =

    var sm  = SUM(amount)

    RETURN

    IF(ISBLANK(sm),0,sm)



    it should display 0 when there is no value if that works for you. 

    Thanks and Regards,

    Sayali

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!