Search code examples
powerbidaxdata-analysisbusiness-intelligence

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.

Solution

  • 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