Measure not totalling correctly when using if statement

[jharada]

I am working on a headcount report and trying to do the following:

Remaining Attrition = round(-([2023_EndHC]*0.015)-[Q4_Terms],0)

- 1.5% is what we think our attrition could be

- The Attrition Measure is using 2 other measures to calculate the data

- This measure shows up in the table matrix well and totals correctly

However, I want to say that if the Attrition is Positive, have it equal to 0 and if the Attrition is positive, the equal Attrition

Attrition Updated = IF([RemainingAttrition]>0,0,[RemainingAttrition])

This works for each line item however, it does not total up for me correctly 😞 I havent gotten it to work afte reading multilple posts.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[v-yifanw-msft]

Hi @jharada ,

 Thank you for your question. Based on the information you have provided, You can try to change the measure:

Attrition Updated Corrected =

SUMX (

    VALUES (TableName[CategoryColumn] ),

    IF ( [RemainingAttrition] > 0, 0, [RemainingAttrition] )

)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Thank you for your questions and support! If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}