Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 😉
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |