Help With DAX For Table Visual

[Anonymous]

Hi,

I have an existing function that's not returning correct results. Appreciate any help please @amitchandak @Jihwan_Kim 

X Proc Resc (Format) = 
var _val = [X Proc Resc]
var _test = [X Del Resc] + [X Carryover] + [X Aged Freight]
return

SWITCH(TRUE(),
_test >=0 && _val >=0, FORMAT(_val, "##0.0%"),
_test >=0 && _val =BLANK(), FORMAT(_val, "General Number"))

As per screenshot, the expected results for the highlighted "Branch" column should be:

Branch	X Del Resc	X Proc Resc	X Proc Resc (Format)	X Carryover	X Aged Freight
Auckland South
Auckland West	0.0%	50.0%	50.0%
Blenheim			0		0

[lbendlin]

You can't report on things that aren't there unless you perform extra steps like adding 0 to the measure or using disconnected tables and cross joins.

[Anonymous · Accepted solution]

@lbendlin yes you're right and I forgot to mention that. So I've managed to solve my issue by tweaking the dax and it's showing expected results.

X Proc Resc (Format)1 = 
var _val = [X Proc Resc]
var _test = [X Del Resc] + [X Carryover] + [X Aged Freight]
var _result =
SWITCH(TRUE(),
NOT(ISBLANK(_test)) && NOT(ISBLANK(_val)), FORMAT(_val,"##0.0%"),
NOT(ISBLANK(_test)) && ISBLANK(_val), FORMAT(0, "General Number"))

return
_result