Home Forums Data Warehousing Analysis Services Filter Dimension Members that don't have any Values in selected Measures RE: Filter Dimension Members that don't have any Values in selected Measures

  • Hi there, thanks for your answer, sadly it doesn't really fix my Problem

    Think about the following Scenario:

    Say i Have 100 Customers that get into a Dimension, and i filter for the current Month, and now only 12 of them have Values in the Measure i am using. currently when i try to filter out specific Customers, i get 100 as oposed to the 12 that could really concern me.Isn't there a way to do this, must be? shouldn't it,

    i mean it must have been annoying to somebody else who was trying to filter and than head to scroll through a bazillion values till he found what he needed.

    Thanks again