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

lucasneedhelp — Mon, 09 Jan 2023 04:31:54 GMT

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!!!!!!

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

Mahesh0016 — Mon, 09 Jan 2023 05:30:07 GMT

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

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

lucasneedhelp — Fri, 02 Jun 2023 06:39:06 GMT

Hi Mahesh0016

sorry for the late response. new to the forum.

i've figured this out

thanks anyway

topic Unable to compare Act vs. Bud when there's both number and percentage in DAX Commands and Tips

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

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

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