Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
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 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |