Is it possible to filter out zero's on a measure? I need to filter out cost that have nothing in them.
In the data item I have:
filter([RateCalc].[CostCalc],[Cost] <>0)
If I put it in the detail filter, it works, but I've read not to use detail filter.
The prohibition against detail filters is really only for dimensional sources.
If you're using an OLAP or DMR source, it's generally better design to filter the specific set you're showing on the axis using the filter function. A measure detail on a multi-axis data container in OLAP may cause unexpected results.
In your case, are you using relational? If so, use the detail filter. If it's a cube, edit the set expression to include the filter.