Forum Discussion

Anonymous

Not applicable

9 months ago

Solved

DAX Calculation help

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
9 months ago
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.

5 Replies

amitchandak
Super User
9 months ago
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
  Not applicable
  9 months ago
  I've used DAX Function = Result have Normal and Up-normal as not executed 'Fine'
  
  Thanks
  - amitchandak
    Super User
    9 months ago
    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.