Forum Discussion

odada11's avatar
odada11
Helper I
3 years ago
Solved

dax

Hello All, I am trying to write a measure that goes thus State Groups = IF ('Crossystate]="Unreconciled", "Unreconciled", if ('crossystate]="paid", "Invoiced", If ('crossystate]="Approved", "In...
Need Help
  • odada11's avatar
    odada11
    3 years ago

    Thank you so much
    i tried it and it returned this error

     

  • TaylorPBI21's avatar
    TaylorPBI21
    3 years ago

    Hi odada11 ,

    Are you making it a calculated column? Try this and amend table name etc to fit your need...😎


    State Groups = SWITCH(
    TRUE(),
    'Table'[Crossystate] = "unreconciled", "Unreconciled",
    'Table'[Crossystate] = "paid", "Invoiced",
    'Table'[Crossystate] = "approved", "Invoiced",
    'Table'[Crossystate] = "unpaid", "NotPaid",
    "Pending"
    
    )

    Many Thanks,

     

    Taylor

     

    LinkedIn: www.linkedin.com/in/taylordownes10 ðŸ˜Š

odada11's avatar
odada11
Helper I
3 years ago

Thank you so much
i tried it and it returned this error

 

TaylorPBI21's avatar
TaylorPBI21
Resolver I
3 years ago

Hi odada11 ,

Are you making it a calculated column? Try this and amend table name etc to fit your need...😎


State Groups = SWITCH(
    TRUE(),
    'Table'[Crossystate] = "unreconciled", "Unreconciled",
    'Table'[Crossystate] = "paid", "Invoiced",
    'Table'[Crossystate] = "approved", "Invoiced",
    'Table'[Crossystate] = "unpaid", "NotPaid",
    "Pending"
    
    )

Many Thanks,

 

Taylor

 

LinkedIn: www.linkedin.com/in/taylordownes10 ðŸ˜Š

  • odada11's avatar
    odada11
    Helper I
    3 years ago

    Thank you so much for your help, is there a way i can make all the "invoiced" appear as one in a drop down filter rather than have several Invoiced.

    Really grateful for your help