Forum Discussion

WillEyedowin's avatar
WillEyedowin
Frequent Visitor
7 years ago
Solved

Count Blanks Table

Hi All,   I would like to make a table in a report which counts whether a store has had 0 sales (blank/lack of data in this case) in a defined period of time.   The main problem I have is the dat...
Need Help
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

WillEyedowin's avatar
WillEyedowin
Frequent Visitor
7 years ago

Hi,

 

Looks like that worked - could you please explain your solution a little so I know exactly what you did?

 

Is this measure the only thing you changed?

 

Zero Sales Store = COUNTROWS(FILTER(SUMMARIZE(VALUES(DateKey[Date]),[Date],"ABCD",SUM(sold[Quantity Sold])),[ABCD]=0))
 
Thanks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Yes. That is all i changed.  The VALUES(DateKey[Date]) portion creates a unique list of all dates from the DateKey Table.  Against every date, we then plot the sale and give a title to this column as ABCD.  We thereafter filter the ABCD column on all values where the value is 0.  Finally we count the days in the filtered Table.

     

    If my reply helped, please mark it as Answer.