Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Converting

Hello,

Could you please help with rounding the values :

Conditions:

KPI = 100% should be 100%

KPI >100% should be 100%

KPI Infinity = should be 0%

My dax: Rounding = IF(if('KPI'[KPI %]>1, 1, 'KPI'[KPI %]), if('KPI'[KPI %]<=1, 'KPI'[KPI %],0))

Eventually, KPI >100% should be 100% - not worked:

SamInogic
3 years ago
Hi Anonymous ,

Could you please try below DAX expression as this will check if the KPI value is less than or equal to 0 then it will round it to 0%.

Rounding = if('KPI Percentage'[KPI %]<=0,0, if('KPI Percentage'[KPI %]>1, 1, if('KPI Percentage'[KPI %]<=1, 'KPI Percentage'[KPI %],0)))

Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at [email protected]
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

3 Replies

SamInogic
Super User
3 years ago
Hi Anonymous ,

Can you try below DAX for rounding column?

Rounding = if('KPI Percentage'[KPI %]>1, 1, if('KPI Percentage'[KPI %]<=1, 'KPI Percentage'[KPI %],0))

Thanks!
Inogic Professional Services Division
Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
Drop an email at [email protected]
Services: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
- Anonymous
  Not applicable
  3 years ago
  
  Thank you!
  But the condition KPI Infinity = should be 0% did not work. If I don't have data for 2024 (Infinity), then it should show 0. Now it is - 100% Can you help?
  - SamInogic
    Super User
    3 years ago
    Hi Anonymous ,
    
    Could you please try below DAX expression as this will check if the KPI value is less than or equal to 0 then it will round it to 0%.
    
    Rounding = if('KPI Percentage'[KPI %]<=0,0, if('KPI Percentage'[KPI %]>1, 1, if('KPI Percentage'[KPI %]<=1, 'KPI Percentage'[KPI %],0)))
    
    Thanks!
    Inogic Professional Services Division
    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!
    Drop an email at [email protected]
    Services: http://www.inogic.com/services/
    Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/