DAX Formula

[elleneal]

Hi,

I am not able to create a calculation as it would appear in Excel. 

I would like a calculated column to return a value with 1 filter applied for the row language (column A) and another filter applied for Tier|LOB (column B). 

As you can see from the table above, the column is providing me with the value for 'T2 1' for the language in the row and ignores the Tier|LOB in the row. When i use the sumif within Excel this works perfectly but when i apply the same formula using Calulate and Sum or SumX and applying the filters it just gives me the value of T2 1 in that row only (see example below).

The purpose of the calulcation is for an if formula. if the row is T1 1 then give me the value for T2 1 for that language.

Thank you very much for your support.

Elle

[andris_ · Accepted solution]

Hi @elleneal,

Please try out the following DAX formula:

Sum if T2 1= LOOKUPVALUE(Datasheet[Extra Calls];Datasheet[Language];Datasheet[Language];Datasheet[Tier|LOB];"T2 1")

Regards,

Andris

[elleneal]

You are amazing! Thank you so much