Conditional measure

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Conditional measure

Conditional measure

Topic RSS Feed

Posts under the topic: Conditional measure

Posted: 4/3/2012

zakzaki
zakzaki
Jedi Youngling 2  points  Jedi Youngling
  • Joined on: 4/3/2012
  • Posts: 1

Hi,

I have a simple fact "sales lines" table with [customer],[reseller],[item], [family item ], [qty] ecc.

I need a measure [Number of customer] which count (distinct count) the number of customers

that buy items in at least 3 different [family item]

Can someone help me :)

Thanx

Vangelis

Posted: 5/3/2012

MMilligan
MMilligan
Padawan 810  points  Padawan
  • Joined on: 6/7/2011
  • Posts: 46

I would use SQL to populate a table that contains all of the customers for a certain period that meets the criteria.  The create a distinct count measure group based on that table.
Page 1 of 1 (2 items)