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.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

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.