Forum Discussion
DAX Measures
Hello All,
I have a table visual data in the below format and trying to get the count of servers which satifies these "Range_Measure " condition.
Please note that the columns
(Actual_Uptime% is a calculated column & Range_Measure is a measure.
| ServerName | Actual_Uptime % | Range_Measure |
| AB1 | 100 | Above 99.99% |
| AB2 | 100 | Above 99.99% |
| AB3 | 100 | Above 99.99% |
| AB4 | 95 | Between 99% to 95% |
| AB5 | 99 | Between 99% to 95% |
| AB6 | 90 | Below 95% |
| AB7 | 75 | Below 95% |
| AB8 | 100 | Above 99.99% |
| AB9 | 100 | Above 99.99% |
| AB10 | 100 | Above 99.99% |
| BC1 | 99 | Between 99% to 95% |
| BC2 | 99 | Between 99% to 95% |
| BC3 | 99 | Between 99% to 95% |
| BC4 | 90 | Below 95% |
| BC5 | 75 | Below 95% |
| BC6 | 99 | Between 99% to 95% |
| BC7 | 99 | Between 99% to 95% |
| BC8 | 99 | Between 99% to 95% |
| BC9 | 90 | Below 95% |
| BC10 | 99 | Between 99% to 95% |
| BC11 | 99 | Between 99% to 95% |
| BC12 | 90 | Below 95% |
| CD1 | 100 | Above 99.99% |
| CD2 | 100 | Above 99.99% |
| CD3 | 100 | Above 99.99% |
| CD4 | 100 | Above 99.99% |
| CD5 | 100 | Above 99.99% |
| CD6 | 100 | Above 99.99% |
| CD7 | 95 | Between 99% to 95% |
| CD8 | 99 | Between 99% to 95% |
I should be able to get the output as below through a Card visual.
Range Measure | Total Count |
Above 99.99% | 12 |
Below 95% | 6 |
Between 99% to 95% | 12 |
Hi Suprith ,
Based on your description, I suggest you can create a calculated column and try again.
- create a calculated column named “Range_Column”.
Range_Column =
var x1='CASE'[Actual_Uptime %]
return
IF(
x1<95,
"Below 95%",
IF(
x1>99.99,
"Above 99.99%",
"Between 99% to 95%"
)
)
- Create a measure to get the count of servers.
Total Count = COUNT(CASE[Range_Column])
Result:
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Suprith ,
Based on your description, I suggest you can create a calculated column and try again.
- create a calculated column named “Range_Column”.
Range_Column =
var x1='CASE'[Actual_Uptime %]
return
IF(
x1<95,
"Below 95%",
IF(
x1>99.99,
"Above 99.99%",
"Between 99% to 95%"
)
)
- Create a measure to get the count of servers.
Total Count = COUNT(CASE[Range_Column])
Result:
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Range Measure would need to be created as a calculated column in order for you to use it in a card visual in the way you want. Not sure if this post will help, but Power BI Order of Operations is a good thing to understand inside out.
Do you have the Range Measure working successfully? Try it as a Calculated Column and see if this helps give you the results you want. Otherwise, please clarify what is working and what is NOT working so we can help better.
