YOY percentage above 100

DAX DAX Calculations
2

Hello @Tee1,

Thank You for posting your query onto the Forum.

Well you can absolutely achieve this type of result using the “SWITCH( TRUE() )” function with the logic stated as below as an example -

Measure = 
SWITCH( TRUE() , 
       [YoY % Total Sale Growth] > 0 && [YoY % Total Sale Growth] <= 1 , [YoY % Total Sale Growth] , 
"N/M" )

I’m also providing some of the links of the videos available onto our EDNA YouTube channel pertaining to this topic.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh