none
MDX Measure - Count based on date RRS feed

  • คำถาม

  • Hi All,

    I am trying to develop a measure to count the number of times something happens daily. This is the condition:

    IIF([Measures].[Sstk Qty] > 0

    AND[Measures].[A+C Quantity] <= 0 ,1, NULL)

    So I want to be able to figure out how many times this happens per month, or week, or quarter, or whatever date slicer I use. Right now this only produces 1 or Null for any given data level. So if this condition was true 9 times in the month of Novemeber and I had month in my query, I would see 9 as the answer. Currently I see 1.

    Thanks,

    Mike

    18 พฤศจิกายน 2562 22:49

คำตอบ

ตอบทั้งหมด