Forum Discussion

sudanaditya's avatar
sudanaditya
Regular Visitor
7 years ago
Solved

DAX formula for the below Sample

Hello Gurus - I am trying to create condition formating on  values with below condition >95 then 1 between 90 to 95 then 2 <90 then 3 Any help is appreciated . Regards Sudan
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi sudanaditya 

    You may create a measure with IF condition like below:

    Condition = 
IF (
    SUM ( 'Sample'[data] ) > 95,
    1,
    IF (
        SUM ( 'Sample'[data] ) < 90,
        3,
        IF ( SUM ( 'Sample'[data] ) > 90 && SUM ( 'Sample'[data] ) < 95, 2 )
    )
)

    Regards,

bvilten's avatar
bvilten
Helper III
7 years ago

Unless there is a particular reason for DAX you can use the Conditional Column feature to do it. 

 

Edit Queries > Add Column > Conditional Column.