count number of rows of each status per month

[lm82]

how do I build a visualisation for above? I need to display total of each status per month e.g. in Jan there are three approved, 2 lost and 2 won. out of total 7 orders. The visualisation needs to show the stats for each month jan-dec and multi year data. 

[danextian]

Hi @lm82 ,

The formula below can be either a measure or a calculated column and  computes the row count by month and status.

=
CALCULATE (
    COUNTROWS ( 'table' ),
    ALLEXCEPT ( 'table', 'table'[month], 'table'[status] )
)

[lm82]

thank you for your response. I am quite new to this so will need little extra help. I have two tables. Date table, which has year, months etc. And another table named orders. In the order table I have record or orders placed over a period of months and years. I would like to build a visulazation similar to below that can show me each month the total status of each order

[danextian]

Please see below:

[lm82]

I am getting single count 

[swikritee_p]

@lm82 , Take Date(Month/Year) or Date on the X-axis and Status as Legend and Count of y-Axis/Values on Clustered column or stacked bar visual 

[lm82]

I am not sure how to do count of y-axis/values. I have tried previous user measure but getting same total for every status. where as I am trying achive something similar to below where every color is the total of number of orders in a given status in that month.