topic Help With DAX For Table Visual in DAX Commands and Tips

Help With DAX For Table Visual

Anonymous — Tue, 02 Aug 2022 03:52:37 GMT

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

Re: Help With DAX For Table Visual

lbendlin — Tue, 02 Aug 2022 22:56:58 GMT

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.

Re: Help With DAX For Table Visual

Anonymous — Wed, 03 Aug 2022 00:39:03 GMT

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