Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I'm trying to create a measure that calculates the total quantity for each product in the selected date, here is an exemple:
Thanks in advance 🙂
Solved! Go to Solution.
@MaJar , Create a measure like
Calculate(Sum(Table[Quantity]), removefilters(Table[Date]) )
or
Calculate(Sum(Table[Quantity]), filter(allselected(Table) , Table[Product] = max(Table[Product]) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
@MaJar , Create a measure like
Calculate(Sum(Table[Quantity]), removefilters(Table[Date]) )
or
Calculate(Sum(Table[Quantity]), filter(allselected(Table) , Table[Product] = max(Table[Product]) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 46 | |
| 44 |