Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, i have a problem with my pie chart. My fact table, Sales has values:
Product OrderDate SaleValue
Prod1 2020-04-05 45
prod2 2020-04-01 90
prod3 2019-02-14 20
prod2 2019-02-10 90
prod1 2018-10-10 10
prod4 2002-01-05 9
I need to create a pie with top 2 categories by salevalue and 3 category as others
pie categories;
prod 2 - 180
prod 1- 55
others (as prod3, prod4) - 29
thanks for help!
Solved! Go to Solution.
it seems as good solution byc it doesnt work with my measure, could You help me? For ranking I create measure like this;
SOS AM =
DIVIDE(
calculate(sum(SaleValue);MONTH(vfact_Points_Details[Date]) = MONTH(TODAY()))
;
CALCULATE(sum(SaleValue);MONTH(vfact_Points_Details[Date]) = MONTH(TODAY());ALL(vfact_Points_Details[Name]))
)
I need ratio percentage sum(SaleValue) to sum(SaleValue) all products
And then do pie chart with product and SOS AM (top)
If i do like in Your article I got 100% for every products without others 😞
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |