Measure does not show correct value after updating data in power bi service

[FelipeBR]

I created a report in power bi desktop and published it in power bi service. All values and graphics were correct. After the first automatic update of the report data on the power bi service, one of the cards stopped showing the value correctly. Can anyone help me to solve this problem? Thank you in advance. Below is the formula for the measure shown on the card, the report on the power bi desktop and on the power bi service.

Formula:

Visual on power bi desktop:

Visual on power bi service after automatic data update:

[gauthamboppana]

@FelipeBR  - Please refresh in desktop version and see if the KPI value is correct with the latrest data. There might some data issues in the latest data.

One suggestion, instead of muyltiple IF statements, can you change it to use Switch statement? Its easy to understand and debug.  Also, you may not need use concatenate in the calculation.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

Did I answer your question? Please mark my reply as solution.

[FelipeBR]

Both data are update. Even the problem only starts when after I publish the report, its dataset is updated in the powerbi service, causing the information of this KPI to be lost. I didn't understand why this is happening. Look this to pictures above:

PowerBI Service report:

PowerBI Desktop report:

The KPI for the total is correct but the percentage doesn't work.