Forum Discussion

Suprith's avatar
Suprith
Frequent Visitor
5 years ago
Solved

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% ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Suprith ,

     

    Based on your description, I suggest you can create a calculated column and try again.

     

    1. 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%"

        )

    )

     

     

    1. 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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Suprith ,

 

Based on your description, I suggest you can create a calculated column and try again.

 

  1. 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%"

    )

)

 

 

  1. 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.