Problem fetching last value of the selected plans in a hierarchical table

[Anonymous]

Hi All,

I have a table like:

PLAN NAME	DATE	FAILED	PASSED	NO RUN
abc	8/1/2021	2	5	1
abc	8/2/2021	3	10	2
abc	8/3/2021	5	15	2
def	8/1/2021	1	3
def	8/2/2021	2	5	1

I also have one slicer which contains unique PLAN NAMES. This can be a single select or multi-select slicer.

Now, I want to grab only the last value of all the columns such as "FAILED" from the above table for all the plans selected in the slicer.

That means, if I selected both "abc" and "def" plans from the slicer, I want last values of the respective FAILED columns and add them up. i.e. ( [LAST FAILED] value of "abc" plan + [LAST FAILED] value of "def" plan which equals to 5 + 2 from the above table.

I know this is possible but I could only fetch the last value from the column and not the selected plans last value.

Any quick help will be appreciated.

Thanks!

[amitchandak · Accepted solution]

@Anonymous , Try one of the two

lastnonblankvalue(Table[DATE], max(Table[Failed]))

calculate(lastnonblankvalue(Table[DATE], max(Table[Failed])), filter(allselected(Table), Table[PLAN NAME] = max(Table[PLAN NAME] )))