Forum Discussion
Solved
Last entry in a filtered selection
Hi Everybody, i cant find a solution to a query that i have to do for the report of my company. The data is based on a excel file where some formulas and the date is already entered in advance. m...
Hi, timelez
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a measure as below.
Result = CALCULATE( MAX('Table'[Index]), FILTER( ALLSELECTED('Table'), NOT(ISBLANK('Table'[Errors Found])) ) )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
timelez - If I am reading this correctly:
Measure = MAXX(FILTER('Table',NOT(ISBLANK([Errors Found]))),[Index])