Forum Discussion
Anonymous
3 years agoNot applicable
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
Anonymous , You have change return like
Sumx(Values(Date[Month]), calculate(iFF) )
1 Reply
- amitchandak
Super User
Anonymous , You have change return like
Sumx(Values(Date[Month]), calculate(iFF) )