求大神告知以下筛选到底哪里出问题啦,跪谢!
2303 = ((sum('AR明细202212'[AR])+SUM('AR明细202303'[AR]))/2)/(SUMX(FILTER('Rev2023-current','Rev2023-current'[业务日期]<=DATE(2023,3,10)),'Rev2023-current'[含税收入])/AVERAGE('AR明细202303'[DSO公式参数]))*30
求大神告知以下筛选到底哪里出问题啦,跪谢!
2303 = ((sum('AR明细202212'[AR])+SUM('AR明细202303'[AR]))/2)/(SUMX(FILTER('Rev2023-current','Rev2023-current'[业务日期]<=DATE(2023,3,10)),'Rev2023-current'[含税收入])/AVERAGE('AR明细202303'[DSO公式参数]))*30
这是一个度量值表达式,你应该是使用了新建表,肯定是报错的,改成度量值就可以了