Forum Discussion
Solved
DAX Help with tricky CALCULATE
Hi Experts! My fact table looks like this: EID AID VAL 1 1 80 1 2 0 1 3 100 2 1 0 2 2 170 2 3 200 3 1 270 3 2 270 3 3 300 4 1 380 4 3 ...
Try this:
Measure =
DIVIDE(
VAR _AID2 =
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 2
)
RETURN
IF(
_AID2 > 0,
_AID2,
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 1
)
)
,
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 3
)
)
Try this:
Measure =
DIVIDE(
VAR _AID2 =
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 2
)
RETURN
IF(
_AID2 > 0,
_AID2,
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 1
)
)
,
CALCULATE(
SUM('Fact'[VAL]),
'Fact'[AID] = 3
)
)
Wow! That worked perfectly and is beautiful DAX code. Exactly what I needed. Many Kudos!
Glad to hear!