Converting

[AidanaY]

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]

Hi @AidanaY ,

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 crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[AidanaY]

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 · Accepted solution]

Hi @AidanaY ,

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 crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/