Need help adjusting a measure to change column outcome

[RichOB]

Hi, I am comparing 24/25 VS 25/26 cases to get the % change.

When the Cases25/26 row is blank, is there a way to have the Case% as empty, or a 0% instead of -100%? The Cases% column is a measure of " = Cases_diff / Cases24/25" so I understand that it naturally gives the minus value currently. 

Thanks

[v-achippa]

Hi @RichOB,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @burakkaragoz and @Ahmedx for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @RichOB,

We wanted to kindly follow up to check if the solution provided by the super user's resolved your issue.

If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @RichOB,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[burakkaragoz · Accepted solution]

Hi @RichOB ,

Great question! I totally get what you’re after. When the Cases25/26 value is blank, you don’t want your Case% column showing -100% (or any weird number), but maybe just blank or 0% instead.

You can tweak your DAX measure a bit to handle this. Try something like this:

dax

Case% = IF(
    ISBLANK([Cases25/26]),
    BLANK(), // or put 0 if you want to show 0%
    [Cases_diff] / [Cases24/25]
)

This way, if Cases25/26 is blank, your Case% will also be blank (or 0 if you prefer). Otherwise, it’ll calculate as usual.

Let me know if this works for you or if you want it to behave a little differently! Happy to help tweak it.

Thanks!
translation and formatting supported by AI

[Ahmedx]

you need use DIVIDE ( Cases_diff , Cases24/25")
https://learn.microsoft.com/ru-ru/dax/divide-function-dax