Forum Discussion
Problem defining measure in report
- 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
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
- Anonymous5 years agoNot applicable
Thank you very much! This worked as requested. -- AYK