Forum Discussion

dplandry's avatar
dplandry
Regular Visitor
8 years ago

OMIT ROWS WITH NO DATA

Hey guys

 

I built a report that shows sales by customer with customers down the left side and months across the top with sales figures.  The report pulls every customer regardless of whether they had sales in the current year.  How can I modify the report to only show customers with sales data?


Thanks

Dwayne

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dplandry,

    Please share sample data of your table and post expected result here. If you want to show this year sales, you can create a calculated column using DAX below, then create a slicer using this column or drag this column to visual level filter and set its value to1.

    Column= if(YEAR(Table[Date])=YEAR(today()),1,0)



    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Please share the sample data for better understanding your issue. 

     

    If a cusotmer doesn' have any sales in a year eg,2017, is there any record regarding this customer in that year, such as total sales = 0 or total sales is null?

     

    Did you try to use advance filter to exclude the customers without sales info?