ellenealFrequent Visitor8 years agoSolvedDAX Formula 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 fi...Show Moreandris_8 years agoHi 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
andris_8 years agoHi 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
andris_8 years agoHi 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
andris_Resolver I8 years agoHi 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
