Forum Discussion
Solved
Power BI - tableau LODs
Hi Team! I am trying to switch from Tabluea to PowerBI, going pretty good, but I really can't wrap my head around Tabluea LODs -> PowerBI. I have 3 tables (visual excel screen below - 3 tables co...
Hi emate88
Give this measure a try
Market Sales = CALCULATE(SUM(Sales[Sales]),ALL(Sales),Sales[Market_id]=MAX(Sales[Market_id]))Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi emate88
Give this measure a try
Market Sales = CALCULATE(SUM(Sales[Sales]),ALL(Sales),Sales[Market_id]=MAX(Sales[Market_id]))
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thanks, that will work as well. I was playing around and found at least 2 more solutions...
Power BI is very similar to Tabluea, but LOD -kind of calcs in tabluea are much easier 😉