DAX Calculation help

[Anonymous]

I created measure in Table 1 as not executing as result

both table have relationship as not executing '1070 code should normal in 'class' please look into DAX Formula and suggest.

Result

desc   class                  type

1020   fine                     no

1060   fine                     no

1070   up-normal        listing

1080  up-normal          no

Class = SWITCH(TRUE(),

'Table1'[Account Code]="1020","Fine",

'Table1'[Account Code]="1600","Fine",

SELECTEDVALUE('Table2'[Type])="listing","Normal","Up-normal")

[amitchandak]

@Anonymous , if this is a measure 
Try like 

Class = SWITCH(TRUE(),

max('Table1'[Account Code])="1020","Fine",

max('Table1'[Account Code])="1600","Fine",

SELECTEDVALUE('Table2'[Type])="listing","Normal","Up-normal")

[Anonymous]

I've used DAX Function = Result have Normal and Up-normal as not executed 'Fine'

Thanks

[amitchandak · Accepted solution]

@Anonymous , Please try 

Class (measure) =
VAR acct = SELECTEDVALUE('Table1'[Account Code]) // or MAX('Table1'[Account Code]) if appropriate
VAR ttype = SELECTEDVALUE('Table2'[Type])
RETURN
SWITCH(
TRUE(),
acct = "1020", "Fine",
acct = "1060", "Fine",
ttype = "listing", "Normal",
"Up-normal"
)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[v-priyankata]

Hi @Anonymous 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@amitchandak Thanks for the inputs.

I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @Anonymous 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.