Forum Discussion
Create total measure
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 🙂
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
1 Reply
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