This content has been marked as final.
Show 3 replies

1. Re: Is there a formula or other way of calculating the current filtered measure against a total of the whole data set being used?
Andrew Watson Jul 29, 2016 12:18 PM (in response to Nikolas Moutafis)1 of 1 people found this helpfulThe {FIXED} LOD calculation will stay static. Without seeing your data try something like the following to get a count of all customers in the data set: {FIXED:COUNTD([CustomerId])}

2. Re: Is there a formula or other way of calculating the current filtered measure against a total of the whole data set being used?
Nikolas Moutafis Jul 29, 2016 12:55 PM (in response to Andrew Watson)Thanks for the response.
I'm getting a "Cannot mix aggregate and nonaggregate arguments with this function" error. I clearly have 2 aggregates unless it treats the FIXED formula as a nonaggregate.
And as I wrote that, I threw a MAX() around the FIXED formula and now I'm all set!! Thanks!!

3. Re: Is there a formula or other way of calculating the current filtered measure against a total of the whole data set being used?
Andrew Watson Jul 29, 2016 1:02 PM (in response to Nikolas Moutafis)Great, happy you've managed to get it working