Forum Discussion
Solved
Sumif DAX Formula
Hi there ;
Could you pls give the formula for below table , i would like to summarize delivered status qty
Hey erhan_79 ,
use this DAX statement to create a measure (https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures😞
sum qty delivered = CALCULATE( SUM('<yourtablename>'[Qty]) , KEEPFILTERS('<yourtablename>'[Status] = "Delivered") )Hopefully, this provides what you are looking for.
Regards,
Tom
1 Reply
Hey erhan_79 ,
use this DAX statement to create a measure (https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures😞
sum qty delivered = CALCULATE( SUM('<yourtablename>'[Qty]) , KEEPFILTERS('<yourtablename>'[Status] = "Delivered") )Hopefully, this provides what you are looking for.
Regards,
Tom