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, guys.
For the following 1st table, I'm struggling to calculate the measure (DaysWithSales>1000) that gives the number of distinct days that each products' sales, are in total (Sum of lines' Sales) over 1000 (2nd table).
Thanx in Advance!!
Kostas
Solved! Go to Solution.
@kostask , display this measure with product in a visual
Countx(filter(Summarize(Table, Table[product], table[Date], "_sales", sum(Table[Sales])), [_sales]>1000),[product])
@kostask , display this measure with product in a visual
Countx(filter(Summarize(Table, Table[product], table[Date], "_sales", sum(Table[Sales])), [_sales]>1000),[product])
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |