Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem defining measure in report

The table below indicates a minimal example of my raw data:   Product Order Day Customer Units Ordered Units Delivered P Apr 1 X 4 3 P Apr 2 X 4 3 P Apr 1 Y 3 1 P A...
  • OwenAuger's avatar
    5 years ago

    Hi Anonymous 

    If you have already written a measure Product-level Service Test, then you should be able to write Products Passing Service Test like this (I assumed the table is named Orders) :

     

    Products Passing Service Test = 
    SUMX ( 
        VALUES ( Orders[Product] ),
        [Product-level Service Test]
    )

     

     

     

    This measure iterates over Products visible in the current filter context, and sums [Product-level Service Test] for each. This will respond to any filters you have applied.

     

    Does this work as expected in your model?

     

    Regards,

    Owen