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
Jack2of3
Helper II
Helper II

SWITCH not evaluating as expected all the time

Two tables. Days Since is a measure based on a numeric field, FREQUENCY_CODE is a numeric field.

Both Filters work as expected on report with numeric options.

When should be "Yes" - Always evaluates correctly.

When should be "No" - Often evaulates to "Yes"

Training Needed =
SWITCH(TRUE(),
UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE]=1 && TRAINING[Days Since] >= 365, "Yes",
UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE]=2 && TRAINING[Days Since] >= 730, "Yes",
UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE]=3 && TRAINING[Days Since] >= 1095, "Yes",
UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE]=5 && TRAINING[Days Since] >= 1825,"Yes","No")

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Jack2of3 , as days since is measure you have to create a measure like

 


Training Needed =
SWITCH(TRUE(),
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=1 && [Days Since] >= 365, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=2 && [Days Since] >= 730, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=3 && [Days Since] >= 1095, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=5 && [Days Since] >= 1825,"Yes","No")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Jack2of3 , as days since is measure you have to create a measure like

 


Training Needed =
SWITCH(TRUE(),
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=1 && [Days Since] >= 365, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=2 && [Days Since] >= 730, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=3 && [Days Since] >= 1095, "Yes",
max(UTTS_MANDATORY_JOB_CLASS[FREQUENCY_CODE])=5 && [Days Since] >= 1825,"Yes","No")

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