DAX : Percentage of a category per day

[Anonymous]

I've been trying for 3 days to find a way to add a calculated column that display the percentage of "closed" state per day.

As you can see I have a "State" column , in it we can find "closed", "active","new"...etc
And a Date column , there can be multiple items per day

What I want is a calculated column that display the percentage of closed state (compared to total : closed,active,new...) per day. I can't find a way to do it, some help would be appreciated

Thank you!

[AlB · Accepted solution]

Hi @Anonymous 

There are five identical rows in what you show. How is that to be taken into account? Try this calculated column:

NewCol =
DIVIDE (
    CALCULATE (
        COUNT ( Table1[State] ),
        Table1[State] = "Closed",
        ALLEXCEPT ( Table1, Table1[Date] )
    ),
    CALCULATE ( COUNT ( Table1[State] ), ALLEXCEPT ( Table1, Table1[Date] ) )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

Sorry, this lines are not the same, my screenshot is just not wide enough, there is item ID's.
Each day we have the state of every item , and their state change with time 

I've tried you formula, adapted it and it finally works, thank you so much !