New answers tagged ssas
There is a huge difference. If you process a cube then it processes the measure groups and partitions inside it. If you process a database then it also processes the dimensions
I had a similar scenario and used the following DAX query... First, to make it simple, I defined a measure to use inside the DAX so I don't have to repeat the formula. Then I used the generate to iterate on the TOPN formula: define measure TableInTabular[NameOfTheMeasure] = COUNTAX(FILTER('Stats', ISBLANK([DeactDate]) = TRUE), 1) evaluate ( addcolumns ...
Top 50 recent answers are included