Forum Discussion
Help With DAX For Table Visual
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 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
2 Replies
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.
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
