Forum Discussion
DAX Conditional Lookup
Stats = CALCULATE(MAX('YourStatus'[Status]),ALLEXCEPT('YourStatus','YourStatus'[ID]))my table is "YourStatus'
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielThanks for your help. I've solved this using the MAXX function to convert the measure "[Account Status2]"
Final Status = CALCULATE(MAXX(VALUES('PN MASTER DATA'[SLCODE]),[Account Status2]), ALLEXCEPT('PN MASTER DATA','PN MASTER DATA'[NAME]))
Stats = CALCULATE(MAX('YourStatus'[Status]),ALLEXCEPT('YourStatus','YourStatus'[ID]))my table is "YourStatus'
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Peejz_Jalmasco
Or with just the id.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi Nathaniel_C
I'm sorry but the column 'Status' is from a measure and is not a column, i don't think that the MAX function will run in a measure -- MAX([Status])
Hi Peejz_Jalmasco , what does the measure look like?
Thanks for your help. I've solved this using the MAXX function to convert the measure "[Account Status2]"
Final Status = CALCULATE(MAXX(VALUES('PN MASTER DATA'[SLCODE]),[Account Status2]), ALLEXCEPT('PN MASTER DATA','PN MASTER DATA'[NAME]))