Forum Discussion

timelez's avatar
timelez
New Member
6 years ago
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...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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.

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

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.