Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 De...
DAX
Help required
  • Anonymous's avatar
    Anonymous
    4 years ago

    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
lbendlin's avatar
lbendlin
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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