undefined

[Anonymous]

Hi all,

I have calculated columns as Day 0, day1, day2 etc.

Based of these columns i have created the measure that sum [day0]/count[total]= overall SLA

This overall SLA i have show under the days columns in table or matrix view.

How i can do it.

Please Help.

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

Test:

You may create a measure as below.

Result = 
IF(
    ISINSCOPE(Test[Days])&&ISINSCOPE(Test[Calculation]),
    SWITCH(
        SELECTEDVALUE(Test[Calculation]),
        "Complaint Count",
        SWITCH(
            SELECTEDVALUE(Test[Days]),
            "Day0",COUNTROWS(FILTER('Table',[Day0]=1)),
            "Day1",COUNTROWS(FILTER('Table',[Day1]=1)),
            "Day2",COUNTROWS(FILTER('Table',[Day2]=1)),
            "Day3",COUNTROWS(FILTER('Table',[Day3]=1)),
            "Day4",COUNTROWS(FILTER('Table',[Day4]=1)),
            "Day5",COUNTROWS(FILTER('Table',[Day5]=1))
        ),
        "Overall SLA",
        SWITCH(
            SELECTEDVALUE(Test[Days]),
            "Day0",DIVIDE(COUNTROWS(FILTER('Table',[Day0]=1)),COUNTROWS('Table')),
            "Day1",DIVIDE(COUNTROWS(FILTER('Table',[Day1]=1)),COUNTROWS('Table')),
            "Day2",DIVIDE(COUNTROWS(FILTER('Table',[Day2]=1)),COUNTROWS('Table')),
            "Day3",DIVIDE(COUNTROWS(FILTER('Table',[Day3]=1)),COUNTROWS('Table')),
            "Day4",DIVIDE(COUNTROWS(FILTER('Table',[Day4]=1)),COUNTROWS('Table')),
            "Day5",DIVIDE(COUNTROWS(FILTER('Table',[Day5]=1)),COUNTROWS('Table'))
        )
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.