CODEWITHSUNDEEP
powerbidaxdata-analysisbusiness-intelligence
Affiq Mirza
Affiq Mirza

Reputation: 47

Count Row of Status in Power BI

i need help in Power Bi on how to count row of status (Critical,Reorder,Cutoff,Ideal,Overflow) as attached in Power BI?

enter image description here

Thank you so much.

Upvotes: 0

Views: 153

Answers (1)

Peter
Peter

Reputation: 12375

Use this calculated table

Status Count = 
SUMMARIZE(
    'Table',
    'Table'[Status],
    "Count", COUNTROWS('Table')
)

With this sample data:

enter image description here

You'll get the following result:

enter image description here

Upvotes: 1

Related Questions