Powerpivot filtering DAX "All"
Hi,
I'm struggling and looking for some good ideas. I have a PowerPivot that shows Planned and Realized values for different parts of a business. The Planned values consolidate values only related to items with a certain status (that the user can select in the filter). The realized values however should always consolidate all values independent of this filter applied. I accomplished this (to some extent) by applying an "All" statement in related the DAX KPI for the Realized values.
The thing is that this solves the value part so that all total values etc. are as they should be (disregarding the filter). The problem is just that when the filter is applied the line items that fall out of the filter criteria is excluded in the presentation of the data (but still considered in the totals).
Is there a way that I can keep the line items for all the related values in the pivot so that the numbers add up in a way that is easier for each user to understand?
Appreciate any guidance on this!
|