so this is a bit of a weird calculation.
I have some intensive calculations (cumulative Sales by attribute)and when a user opens up the report page with the calculations.
I want to find a way that if a user lands on the page and the data selection returns a large set of data then I want to ->
- short circuit the difficult calculation to return blank (Cumulative Sales by Attribute returns BLANK if rowcount exceeds the limit otherwise it calculkates the true value)
- Make visible a message saying “Data set size exceeds x number of rows please filtert he report”
CountRows(ALLSELECTED(FactTable) could give me what I want but I notice
- the warning message works as the contect is the page and so returns the correct calc.
- When this is used withing the chart the number of rows that are in ALLSELECTED changes to a lower number.
I am looking for a way to calculate the number of rows in the fact table that are selected when you land on a report page and for this to be available even if it is displayed inside a chart that has further filters.