I need a KPI in a form:
if X then A
if Y then B
if (X or Y) then (A+B)
else null end;
As I want to use it in an olap as dimention (first column) where the other KPIs deliver values for A,B and A+B, it is is not the optimal solution to split it into two tables (looks not good).
It seems for me, it is not possible to use CASE WHEN as it uses ELSE after the first condition and automatically excludes the A+B.
Do you know if there is a solution?