Seeded Measure Exceptions: Days Expression
SummaryI need to know expression of measure Exception: Days. I will modify the expression to show maximum of Days past due rather than Sum of Days past due.
We configured a tree graph Items with Past due Purchase Orders and 2 measures Exceptions: Quantity and Exceptions: Days (refer screenshot).
Above, Exceptions: Days is showing sum of Days Past Due column (refer screenshot below).
Note: Exception is Past due Orders.
In tree graph, User wish to see purchase order maximum due day (For the case shared in screenshot output expected is 57).
Duplicated Exceptions: Days measure and changed aggregation parameter for time and other dimension as Maximum.