Power BI - tableau LODs

[emate88]

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 connected by id keys) and I want to show in 1 table list of my product + sales of this product + sum of market sales for each product + market Share. 

In tabluea I have to use : {Fixed [Market Name]: sum([Sales])} and this gives me for each product /row - value of respective market in Power BI - i am stuck, I was trying to play with All / ALLEXCEPT - but this doesnt seem to work (creates duplicates and shows total, and not sales per Market)

## Ok, I managed to figure out, why I have duplicates, but still can't agreegate sales on the Market Level.

Thanks,
M

[v-jingzhan-msft · Accepted solution]

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!

[emate88]

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 😉