topic Re: Select a Specific Cell on a Table using Conditional Statement in DAX Commands and Tips

Select a Specific Cell on a Table using Conditional Statement

Anonymous — Fri, 08 Apr 2022 05:04:29 GMT

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 [Count] column which is "360" even though I've already used an IF statement that selects "Today" in [TODAY_SELECTOR ] column and "DAY" in [SHIFT SELECTOR] column.

So how do I get the value of 60 as it is the Latest Value in the "Today" and "Day Shift" of my data?
attached below is the image of my PowerBI.

Thank you!

Re: Select a Specific Cell on a Table using Conditional Statement

HotChilli — Fri, 08 Apr 2022 07:56:14 GMT

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)

Re: Select a Specific Cell on a Table using Conditional Statement

V-lianl-msft — Wed, 13 Apr 2022 03:45:18 GMT

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.