Forum Discussion

JiayiHe炮饱饱's avatar
JiayiHe炮饱饱
Regular Visitor
3 years ago

NEED HELP! Problem during quick measure

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 !

 

Need Help

3 Replies

    • JiayiHe炮饱饱's avatar
      JiayiHe炮饱饱
      Regular Visitor
      3 years ago

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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    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.