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,

 

Share the link from where i can download your PBI file.

    • 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