Forum Discussion

Robczuba's avatar
Robczuba
Regular Visitor
3 years ago
Solved

Filter to show only Concluded tasks

Hello Everyone. 

 

I'm strugling to make measure in PowerBI to show only systems that all task were concluded, from a table.

 

 

Can someone help me??

Thank you

 

  • Alf94's avatar
    Alf94
    3 years ago

    Hi Robczuba ,

     

    Can you please try the following?

     

    Mesure = 
    IF(
        MAX( 'Table'[Status] ) = "Concluded",
        "Concluded"
    )

     

    Result:

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,

     

1 Reply

  • Alf94's avatar
    Alf94
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hi Robczuba ,

     

    Can you please try the following?

     

    Mesure = 
    IF(
        MAX( 'Table'[Status] ) = "Concluded",
        "Concluded"
    )

     

    Result:

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,