Day Count Calculation turns wrong , and The COndition also turn Blank

[Chanleakna123]

hi , i use Status now calculation which use NOW - Date , and the result is in #days as i shared the calculation above. 

but the dayy count turns some wrong and some right , i see in September there're blank data on the other calculation i linked with Status Now , i can see the day count was wrong. 
can you help me to solve this ? 
i shared you below link for POwer BI , kindyly assist me on this case. 

https://drive.google.com/file/d/1qnR7otuTCxxfA1VOe_leNUKRHtzNorxj/view?usp=sharing

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

I don't see the existed table visuals in your provided report, so I created table and slicer visuals as displayed in screenshot. 

The reason that you got 144 when you subtract 11/9/2018 from Now() could be caused by that you set aggregation for the Status Now calculated column in the table visual. Please replace Now() as Today() for Status Now = TODAY()-'Report of Commitee'[Date], as Now() contains time value will affect the final result. Then drag this column to the table visual, set Don't Summarize. see attached file. 

By the way, Issues forum is for reporting Power BI bugs. Regarding the issue authoring a report in Power BI desktop, please post a thread in Desktop forum next time. 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft hi , looks like i get the late response on Desktop 😞 
Any trick to get fast response ? 😞 now i'm posting on Desktop with multiples Questions. 

thx 

[v-qiuyu-msft]

Hi @Chanleakna123,

Power BI forum support engineers will response in the thread once this thread has been created for 12 hours. Forum community members will provide suggestions if they find the thread and have an idea without any limitation. To get quick and better response, you can follow this blog to provide detail information: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490...

Regarding your question in this thread, is my previous post helpful for you to solve the issue? 

Best Regards,
Qiuyun Yu