Forum Discussion

amateu's avatar
amateu
Frequent Visitor
6 years ago
Solved

Make a visual table

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 ...
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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())

amateu's avatar
amateu
Frequent Visitor
6 years ago

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's avatar
v-diye-msft
Community Support
6 years ago

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())