Measure calculation subtraction

[bzeeblitz]

I have below table visuals and I need to calculate subtraction 

NOTACTIONED output is Totalcount-Action and it should not be negative 

Date.          TOTALCOUNT.   ACTION  NOACTIONED

13/3/25.        20.                   62.             42

[bhanu_gautam · Accepted solution]

@bzeeblitz Open your Power BI report and select the table visual where you want to add the NOACTIONED column.
Click on the "Modeling" tab and then "New column" to create a new calculated column.
Enter the following DAX formula:

NOACTIONED = IF([TOTALCOUNT] - [ACTION] < 0, 0, [TOTALCOUNT] - [ACTION])

[Cookistador · Accepted solution]

According to the dataset you passed, you have to use ABS
NOACTIONED = ABS([TOTALCOUNT] - [ACTION])

Or just to do:

NOACTIONED = [ACTION] - [TotalCOUNT]

[randomUser21 · Accepted solution]

NOTACTIONED = MAX(0, [TotalCount] - [Action])

• [TotalCount]-[action]: This part calculates the difference between the two measures [TotalCount] and [action].

• max(0,..) The max function ensures that if the result of the subtraction is negative, it will return 0  instead of a negative number. Essentially, this function compares 0 with the calculated result, and returns the larger of the two. So, if the difference is negative, it will return 0 , and if it's positive, it will return the actual difference.

[Cookistador · Accepted solution]

According to the dataset you passed, you have to use ABS
NOACTIONED = ABS([TOTALCOUNT] - [ACTION])

Or just to do:

NOACTIONED = [ACTION] - [TotalCOUNT]

[bhanu_gautam · Accepted solution]

@bzeeblitz Open your Power BI report and select the table visual where you want to add the NOACTIONED column.
Click on the "Modeling" tab and then "New column" to create a new calculated column.
Enter the following DAX formula:

NOACTIONED = IF([TOTALCOUNT] - [ACTION] < 0, 0, [TOTALCOUNT] - [ACTION])