hi all…newbie here and an accountant learning how BI works.
i’ve developed a report showing new customers with the following code
New Customers = VAR CustomerTM = VALUES('Customer Invoice Report (A'[To]) VAR PriorCustomers = FILTER( CustomerTM, CALCULATE ( MIN('Customer Invoice Report (A'[Date]), ALL(Dates) )<MIN (Dates[Date]) ) RETURN
everything seems to work well on the month by year and drilldown day by month
i have a year slicer up the top
when i click on 2018 the data appears. when clicking on 2017 i get a blank report screen despite there being data
not sure what im doing wrong