Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
You are amazing! Thank you so much
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |