Dax IF Formula totals are incorrect?

[abriggs]

I'm trying to write a measure that will pull through an amount if it's positive and to exclude the negatives. The dax IF formula is doing that for the guts of the data...but the total is not reflecting it... thoughts? I appreciate your help! 

[abriggs]

Sorry for my delay - it worked. Thank you!!! 

[v-jingzhang]

Hi @abriggs 

Has the problem been solved? If so, you may accept the appropriate post as the solution or post your own solution to help other members find it quickly. If not, can you please share some sample data or sample PBIX file so that we can try to find the targeted measures? Thanks very much.

Best Regards,

Community Support Team _ Jing Zhang

[amitchandak · Accepted solution]

@abriggs , if values need to be ignored at the row/line  level. Then try

Measure = CALCULATE(SUMX(filter('Table','Table'[Values] > 0),'Table'[Values]))

If the filter is after grouping data, say at account no
Measure = CALCULATE(SUMX(values('Table'[Account No]),if('Table'[Values] > 0, 'Table'[Values] , blank())))

[abriggs]

Hi! Thank you for your response. 

So what you've said makes sense and works when the values is not a previous calculated measure, else it's not working. 

When I recreated this.... my values is a prior calculated measures....thoughts?

Measure = CALCULATE(SUMX('Table','Table'[Values]),'Table'[Values] > 0)

[FrankAT]

Hi @abriggs 

you can try it like this (I used my own sample data):

Measure = CALCULATE(SUMX('Table','Table'[Values]),'Table'[Values] > 0)

Sum of Values = IF(SUM('Table'[Values]) <= 0 , 0 , [Measure])

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)