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.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add plus zero to the end of your formula.

 

i.e.

Sales = SUM(Sold[Quantity Sold]) + 0

 

As a side note, i notice you are using Calculate but for no purpose. You can remove that from your formula.