Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Solved! Go to Solution.
Hi @Anonymous ,
Let me know if this measures work.
Hi @Anonymous ,
Let me know if this measures work.
You might consider replacing ALLSELECTED with an ALLEXCEPT or REMOVEFILTERS. Not certain what filters you want to keep and what you want to remove for your "ALL" part of your calculation.
Hi @Greg_Deckler,
I'm not really sure with the "ALL SELECTED" but I cannot get the percentage of sku sum/total sku sum without it. If I remove it the result is 100% all data.
@Anonymous - Sample data posted as text to recreate would really help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
It sounds like you have a SKU. And SKU's are grouped into Groups. You have some other dimensions. You want to calculate a particular SKU's impact on a Group keeping your other dimension selections such as date, etc.
That is a fairly sophisticated calculation and depends greatly on exactly how your data is laid out.
Hi @Anonymous
Try ALLSELECTED() without specifying a table.
Hi @Anonymous
What would you expect to see, if you expecting to see the percentage of total regardless of the filter context then you can use ALL() instead.
Hi @Greg_Deckler @Mariusz, Thank you for tryring to help me
Here is an example of my data
I have Table A columns SKU Product, SKU Value, SKU Distributor, Sku date
I put SKU Product and SKU value in table 1 then I used product, distributor and date as a filter.
Chart Table 1:
SKU NAME SKU VALUE Distributor
SKU A 24 Distrubutor A
SKU B 20 Distrubutor A
SKU C 30 Distrubutor B
Chart Table 2:
Distrubutor Name TOTAL SKU VALUE
Distrubutor A 180
Distrubutor B 200
Distirbutor C 300
I used the same field/column called Sku_Value in both tables the difference is in first table I used product and in second is distributor. The measure that I need to do is get the percentage of the sku
Formula: SKU %= SKU Value(Chart Table 1) / Total SKU value(Chart Table 2) * 100 %.
Hence I have the measure:
Could be. Could be a missing relationship. Could be a few other things. Would need to see how your data is laid out, is everything in a single table? Can you provide sample data to reproduce the problem?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
41 | |
31 | |
23 | |
23 | |
22 |