How to combine two DAX functions into one?

[Anmolgan]

I have two dax functions that looks like this below:

Measure4 = CALCULATE(sum(f_Kronos[Minutes]) - "60", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 60"))

Measure 3 = CALCULATE(sum(f_Kronos[Minutes]) - "30", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 30"))

I want to combine them into single formula so that I can get the above two working as per single column in the table, is that possible?

[edhans]

Combine them how? Either/Or would be OR() or ||, And would be AND() or &&, or you could evalueate with an IF() statment to return one or the other.

If you want to add them, just put a + between them.

Otherwise, please explain your desired output.

[Anmolgan]

@edhans I want to nest the calculated columns together with OR statment but do not know how to do that.

[edhans]

Is this what you want?

New Column =
OR(
    CALCULATE(
        SUM( f_Kronos[Minutes] ) - "60",
        FILTER(
            f_Kronos,
            f_Kronos[Subtraction Column] = "Subtract 60"
        )
    ),
    CALCULATE(
        SUM( f_Kronos[Minutes] ) - "30",
        FILTER(
            f_Kronos,
            f_Kronos[Subtraction Column] = "Subtract 30"
        )
    )
)

 Without seeing your data or what you are doing, hard to know. 

[Anmolgan]

@edhans  This gives me True and False values only in place of the columns, I need to subtract 60 and 30 according to the conditional column that I have, in other terms, subtract 60 minutes from minutes column where minutes are more then or equal to 540, and subtract 30 from those where minutes are less then 540, I hope am able to explain you now.

[affan]

Hi @Anmolgan 

Please try the below measure 

Measure 5 = 

var _30=CALCULATE(sum(f_Kronos[Minutes]) - "30", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 30"))
var _60=CALCULATE(sum(f_Kronos[Minutes]) - "60", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 60"))

Return  

IF(_30=-30,_30,_60)

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan Farooqi

[Anmolgan]

@affan  It helped but its not subtracting the amounts from the hours measure.

[Anmolgan · Accepted solution]

@affan @edhans  I used below to solve my issue:

Working Hours = var a= IF('f_Kronos'[Subtraction Column]="Subtract 60" || 'f_Kronos'[Subtraction Column]="Subtract 30",'f_Kronos'[Minutes]-60,'f_Kronos'[Minutes]-30)

var b= a/60

return b

[Anmolgan]

Below is the file where am trying to do this, check page 2 and measure 3 and measure 4

https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EU7vG5uMJF5GiThNdPHPY5UBNfimkU...