Variable table reference?

[Anonymous]

Hi!

I would like to build a solution in SSAS tabular similar to the aggregations functionality in Power BI.

Because the dataset is huge, basically I want to preaggregate the fact data in differrent tables with different granularity.

By using the ISCROSSFILTERED function I can figure out which fact table is best suited to use depending on which dimensions that are filtered.

It would be nice to have this logic as a central measure/function instead of copying it for each different table.

For example if I had a measue named resolveSalesTable that returns a table I could then write each measure as Sales = SUM(resolveSalesTable[Sales]),  Cost = SUM(resolveSalesTable[Cost]) and so on.

Is this possible?

[Anonymous · Accepted solution]

"For example if I had a measue named resolveSalesTable that returns a table"

Out of luck: measures can't return a table.

Best
D