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:

table


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?

newTable

 

Thanks

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

3 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

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