Forum Discussion
Select a Specific Cell on a Table using Conditional Statement
Hello, in the [Count] column, I've wanted to return that value "60" on the [Latest] column that is unique and dependent on the [PO #] column. Its currently returning the value of the last cell in [Co...
Hi Anonymous ,
Replace MAXX() with :
CALCULATE(MAX('Table'[COUNT]),FILTER('Table','Table'[PO #]=EARLIER('Table'[PO #])&&'Table'[SHIFT SELECTOR]="DAY"&&'Table'[TODAY SELECTOR]="TODAY"))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Add the TODAY_SELECTOR and SHIFT_SELECTOR to the FILTER.
At the moment the FILTER creates a table of ALL the COUNT values for the current PO# ( even though it only does that for the rows that meet the conditions in the IF statement)