NEED HELP! Problem during quick measure

[JiayiHe炮饱饱]

Greeting , 

Need support on below .Thanks in advance !

I am using quick measure ,but found error massage as screenshot.

It's for attrition report, need update monthly. Strangely, the measure could use for first seven month, after I update the folder for Aug.& Sept. ,the data goes wrong . 

YTD File Number =

IF(

    ISFILTERED('日期表'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    TOTALYTD(DISTINCTCOUNT('HC List'[Source.Name]), '日期表'[Date].[Date])

)

Could you please suggest how to fix it ?

Attach data form[日期表] as below.

Thanks again for your time !

[v-yalanwu-msft]

Hi, @JiayiHe炮饱饱 ;

Sorry you provided too little information to determine the cause of the error and didn't see your formula error message

please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

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

[wdx223_Daniel]

try to mark your datetable as date table

[JiayiHe炮饱饱]

thanks for your reply ,didn't get it , can you suggest how to change ?