Power BI Chart for Project Status

Anonymous , refer if my blog on the same can help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

Anonymous Seems like:

Project Status Measure = 
  VAR __LastDate = MAX('Table'[AssignedPlanned])
  VAR __Status = MAXX(FILTER('Table',[Assigned Planned] = __LastDate),[Activity Status])
RETURN
  __Status

This will get you your table. For the graphic, you will have to use a disconnected table of your status values. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

DataInsights amitchandak  Please help..am struggling with this requirement. A solution can solve 80% of my worries.

Hi, Anonymous 

You can try the following methods.

Column:

Project Status = 
Var _MaxComplete=CALCULATE(MAX('Table'[%Complete]),ALLEXCEPT('Table','Table'[Project ID]))
Var _MinComplete=CALCULATE(MIN('Table'[%Complete]),ALLEXCEPT('Table','Table'[Project ID]))
VAR _ResultComplete=IF(_MaxComplete=1,_MinComplete,IF(_MinComplete=0,_MaxComplete))
return
CALCULATE (
    MAX ( 'Table'[Activity Status] ),
    FILTER (
        ALL ( 'Table' ),
        [%Complete] = _ResultComplete
            && [Project ID] = EARLIER( 'Table'[Project ID] )
    )
)

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.