Monthly Summary Table

Hi Masikonde ,

I think "No Data" is displayed in Marketing because there are multiple Marketings in September. You can change the formula in Days to Close to the following:

Days to Close = IF(ISBLANK(SUM(Days2Close[Days2Close])),"No Data",SUM(Days2Close[Days2Close]))

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Days to Close = IF(ISBLANK(SUM(Days2Close[Days2Close])),"No Data",SUM(Days2Close[Days2Close]))

The above DAX formula does gives the ability to show Days to Close for each month selected, but at default it shows sum of all months. Is there way to set the DAX to default to current month?

Hi Masikonde ,

You can try the following measure:

Days to Close = 
var __MAXDATE=CALCULATE(MAX('Days2Close'[Date]),ALL('Days2Close'))
var __measure= IF(ISBLANK(SUM('Days2Close'[Days2Close])),"No Data",SUM('Days2Close'[Days2Close]))
var __measure2 = IF(ISBLANK(CALCULATE(SUM('Days2Close'[Days2Close]),FILTER('Days2Close','Days2Close'[Date]=__MAXDATE))),"No Data",CALCULATE(SUM('Days2Close'[Days2Close]),FILTER('Days2Close','Days2Close'[Date]=__MAXDATE)))
return IF(HASONEVALUE('Days2Close'[Date]),__measure,__measure2)

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQm1f8bg8ytHkVoVIpdhn7EBaYoL_NVi9yCt7aVyvxTU7A?e=IfZ7gX

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.