Unable to compare Act vs. Bud when there's both number and percentage

[lucasneedhelp]

Hi guys,

I'm stuck with a DAX expression here when comparing actuals vs. budget that contain both number and percentage.

The formular i use to get Actual and Budget is:

SWITCH(

    SELECTEDVALUE('P&L Structure'[P&L Description]),

    "Event Delivery Margin $", FORMAT(CALCULATE([Event Delivery Margin $],ALL('P&L Structure')),"#,##0,.0"),

    "Event Delivery Margin %", FORMAT(CALCULATE([Event Delivery Margin %],ALL('P&L Structure')),"0.0%"))

so that I can have both number and percentage in my Matrix visual like below

then i use iserror(value(),blank()) to convert text to value, so that i can do another measure to compare act vs. bud, but it only returns number and leaves % as blank

any idea why it happens and how can i correct it?

thanks heaps!!!!!!

[Mahesh0016 · Accepted solution]

@lucasneedhelp  can share your measure to compare act vs. bud.

[lucasneedhelp]

Hi Mahesh0016

sorry for the late response. new to the forum.

i've figured this out 

thanks anyway