Forum Discussion
Measure not totalling correctly when using if statement
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.
2 Replies
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.
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-Forum/ba-p/963216
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/1447523
