Dax Total incorrectly 0 (Currently using If with Text)

[Anonymous]

Good Morning, 

I currently have the below formula that brings through the correct figure when filtered by location (see below), however the total is 0 despite values being present, This is likely because I have embedded values with text. how do I sum the values and ignore the text (but also keep the text within the Matrix)?

Lost_Margin = 
var iFF=
IF('PED Tracker'[PED_Sales]/ [Gross_Sales] = 0 && 
                    [Gross_Sales]>0,[Gross_Sales]*[Avg_ped_pen]/1.2*0.72,
                    IF('PED Tracker'[PED_Sales]/ [Gross_Sales] = 0 && [Gross_Sales]<=0,"Dark",0))

                    Return iFF

Thank you for your help! 

Kind regards,

AF

[amitchandak · Accepted solution]

@Anonymous , You have change return like

Sumx(Values(Date[Month]), calculate(iFF) )

Check - https://www.youtube.com/watch?v=ufHOOLdi_jk