Forum Discussion
Post Patronadd columns / lookupvalue virtual Table
Hi, first and foremost thank you! I have solved the problem with a calculated column. Using powerbi as excel never fails lol.
The issue seems to be related with the model and some circular dependencies since RH table is a summarized table, this is really a mess by now. Although your tip was good I also tried Calculate(first non blank) with a blank result... But is the syntax of my measure (just for the sake of understanding) correct? In a simpler model would work?
Community ChampionHi campelliann
can you please share screenshots of the visual. Initially let's say that LOOKUPVALUE returns blank incase it returned multiple rows. If this is your case then you need to summarize theTriskell Completo table to same granularity of the RH_projecto table perhaps using SUMMARIZE to aggregate MAX values of the Completo'[Produção]. If you can share information I might be able to help further. Thank you and have a great day.
campelliannHi, first and foremost thank you! I have solved the problem with a calculated column. Using powerbi as excel never fails lol.
The issue seems to be related with the model and some circular dependencies since RH table is a summarized table, this is really a mess by now. Although your tip was good I also tried Calculate(first non blank) with a blank result... But is the syntax of my measure (just for the sake of understanding) correct? In a simpler model would work?- tamerj1
Pleaseure to hear that. Yes indeed you need to have clean data and proper relationships before doing DAX. Keepup the good work. Good luck 👍