Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dax Total incorrectly 0 (Currently using If with Text)

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