Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |