#1
|
|||
|
|||
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! |
Tags |
dax, filter, powerpivot |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I delete the names under "Exceptions" when I use the "Restrict Editing" feature in Word? | MengS | Word | 0 | 02-25-2015 02:57 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon | CensorTilSin | Outlook | 1 | 12-11-2013 12:05 PM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |