Forum Discussion

Anonymous's avatar
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   cl...
Need Help
  • amitchandak's avatar
    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.

Anonymous's avatar
Anonymous
Not applicable
9 months ago

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

 

Thanks

amitchandak's avatar
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.

  • v-priyankata's avatar
    v-priyankata
    Community Support
    9 months ago

    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's avatar
      v-priyankata
      Community Support
      9 months ago

      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.