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, '...

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/

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?