Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Hi @Razhior ,
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.
Hi @Razhior ,
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)
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |