Make a visual table

[amateu]

Hi all,

I have a table with the following data:

I want to visualizate in a page, a table with the next info extracted from the previous table. (First date and its fail for each ID) What page filters or visual filters should I add in order to view the following table?

Thanks

[v-diye-msft]

Hi @amateu 

I don't quite understand your logic about the filter. it's based on the most minium date by ID?  If yes, you'll need a measure. 

If just simply filter B&D , you can sue the filter pane.

[amateu]

I need that the app tell me the first fail, this is an example but in reality I will not know what the fail is. How can I do it by the measure you say?

Thanks

[v-diye-msft · Accepted solution]

Hi @amateu 

Please use below measure:

Measure = var a = CALCULATE(MIN('Table (2)'[Date]),ALLEXCEPT('Table (2)','Table (2)'[ID]))
Return
IF(a=MAX('Table (2)'[Date]),CALCULATE(MAX('Table (2)'[Fail]),FILTER('Table (2)',[Date]=a)),BLANK())