create Measure

[sprao]

Hi Team,

please help me to create measure for below scnario

[Anonymous · Accepted solution]

Hi @sprao ,

Please create a new mesure:

Group max = 
MAXX (
    SUMMARIZE (
        'Table',
        'Table'[Project Name],
        'Table'[Date],
        'Table'[Status],
        "Count", COUNTROWS ( 'Table' )
    ),
    [Count]
)

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[mh2587]

StatusCount = COUNT('YourTable'[Status])