在pbix里还可以这么写
enrollment in pbix =
CALCULATE (
COUNTROWS ( result ),
FILTER (
result,
result[分数]
>= CALCULATE (
VALUES ( passingscore[分数线] ),
CALCULATETABLE (
TREATAS (
SUMMARIZE ( result, result[报考学校], result[籍贯] ),
passingscore[学校],
passingscore[招生地区]
)
)
)
)
) |