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?
