Hi Sam/Team - I am trying to gain a better grasp on Virtual Tables as it’s been the most challenging to learn. I was reading through the above blog post which helps. However, I was curious (maybe I missed it), couldn’t you just use this measure?
When I put them side by side, they have the same values with the only difference being the total at the bottom. I’m having trouble understanding what exactly would be the benefit here of using “Overall Ranking Virtual Table” over the measure for “Overall Ranking” where it sums each individual measure? Even when I remove the individual Ranking measure columns on the table, the Overall Ranking values remain the same.
Hi @Jordan.Petty - One benefit I can easily see is you can create a single measure instead of creating “4” measure for calculating individual Rank and Overall Rank.
Also, there are multiple benefits of creating virtual tables when you are working with Advanced DAX calculations. If you scroll through few Forum posts it will be used extensively across them.
Per @ankit 's response, if you’re looking for other virtual table examples in the forum, @Melissa and I have adopted a convention where for virtual table variables within measures, we often name them “vTable”. If you search on this term, you will find a ton of virtual table-related solutions with PBIX files you can explore to better understand the techniques used.
Hi @Jordan.Petty, did the response provided by @ankit and @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.
I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!
Hi @Jordan.Petty, we’ve noticed that no response has been received from you since the 13th of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Jordan.Petty, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
