Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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"))

 

 

qsmith83_0-1659411490203.png

 

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

BranchX Del RescX Proc RescX Proc Resc (Format)X CarryoverX Aged Freight
Auckland South     
Auckland West0.0%50.0%50.0%  
Blenheim  0 0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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
Not applicable

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors