我已经编写了一个SQL子查询,我正在try 在Power BI中重新创建它,但它比我想象的要复杂得多,而且我没有获得正确的值.
SQL:好的,好的.
select sum(x.totalbays)
from
(
select distinct day_id, sum(distinct ranged_bays) as totalbays from overviewTable
group by day_id
) x
Total in SQL:好的,好的. 15,219,683.76
DAX:
TestMeasure =
SUMX (
SUMMARIZE ( 'Overview Table', 'Overview Table'[day_id], "TotalBays", SUM('Overview Table'[ranged_bays])),
[TotalBays]
)
Total using DAX: 87,023,857.19
任何帮助都将不胜感激.