Filtering customers

[deankavon]

hi!

I've used a measure to mark my customers as "Active" and "Not active". The "active" set returns a value of 1, while the "not active" returns a 0..

Now, is there a way to filter these "not active" customers out of the pivot table? not to show them at all? The table gets huge if it shows the "not active" customers.

My formulas goes like this:

For new customers:

=CALCULATE('RVC Reports'[CUSTOMERS TILL NOW]-'RVC Reports'[PREVIOUS CUSTOMERS])

For previous customers:

=CALCULATE('RVC Reports'[DISTINCT CUSTOMERS];DATESBETWEEN(DATES[FullDate];BLANK();MIN(DATES[FullDate])-1))

For distinct customers:

COUNTROWS(DISTINCT('RVC Reports'[BOOKING PARTY]))

For Customers till now (all):

=CALCULATE('RVC Reports'[DISTINCT CUSTOMERS];DATESBETWEEN(DATES[FullDate];BLANK();MAX(DATES[FullDate])))



Any help would be appreciated!

 

[Rijnsent]

Hi Deankavon,

can't you just move the "active/not active" column to the "Filter" part of your pivot table? Otherwise, could you please post a link to your (anonymized/simplified) file on e.g. dropbox/skydrive/etc?

Cheers,

Koen