Friends. I'm calculating the number of days in the month where the SLA% for that day met or exceeded the SLA% target. I'm then calculating this number as a percentage of the total days MTD. The steps that I'm following are as follow: I use summarize columns to calculate the average SLA per date, and I calculate the average SLA as an added column. I then add a flag column to flag each row (date/SLA) as whether it met the SLA (0/1). I then count the rows with flag=1 and divide that by the total rows, and that gives me the percentage. That works fine for the current month. It only works if I present the result on a card visual. If I try to do it in a table or graph where the x-axis is month, I get the below error. My goal is to present in a graph or a table each month along with the percent of days where the SLA was met during that month. Any hint/suggestion is appreciated.
Error Message:
MdxScript(Model) (705, 35) Calculation error in measure 'Table'[Days SLA Met Against Target]: SummarizeColumns() and AddMissingItems() may not be used in this context.
