Percent of cases closed on the same day for each month, not percentage of grand total.

[rovert333]

I am counting same day case closures month over month.  I want the columns to be what percentage of cases were closed that month, not over the course of the entire year.  Please advise.These are the number of cases closed.trying to get these to be % of each month

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[v-yuezhe-msft]

@rovert333,

You would need to create a measure to calculate case numbers of each month, then use the following DAX formula to calculate percentage. If you have questions about the DAX, please share dummy data of your table.

percent= closed cases of each month/all cases of each month

Regards,
Lydia