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 People,
Most of my data is detailed item line level and is not summarized data.
An example, multiple orders and each item of an order stored on a separate line:
Order | Item | Price |
1000 | Laptop | €850 |
1000 | Keyboard | €150 |
1001 | Laptop | €650 |
1001 | Keyboard | €100 |
1002 | Laptop | €1.250 |
I want to know how many orders are smaller than €1.000.
Can somebody tell me how I can calculate this without creating a new table?
Thank you in advance.
Solved! Go to Solution.
@jhaastBI , Try measure like
count order = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [Order])
Sum Price = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [_1])
@jhaastBI , Try measure like
count order = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [Order])
Sum Price = countx(filter(summarize(Table, Table[Order],"_1" ,sum(Table[Price])), [_1]<1000), [_1])
Thank you a lot! That is the solution.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |