Convert calculated column into a Measure

[DK-C-87]

I've got this calculated column : 

Helper = 
VAR _1 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Business Cases] <> BLANK())
VAR _2 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Storbageri] <> BLANK())
VAR _3 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Bageri] <> BLANK())
VAR Samlet = _1 + _2 + _3
RETURN
Samlet

If I put this into a measure I do not get the same result. 
I have tried myself to make changes, so it should work, but without success. The closest i've got is this one : 

Helper = 
VAR _1 = COUNTX(HighlightGBS, CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Business Cases] <> BLANK()))
VAR _2 = COUNTX(HighlightGBS, CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Storbageri] <> BLANK()))
VAR _3 = COUNTX(HighlightGBS, CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Bageri] <> BLANK()))
VAR Samlet = _1 + _2 + _3
RETURN
Samlet

But it still don't work.

Anyone who can help, please ? 

[rajendraongole1 · Accepted solution]

Hi @DK-C-87 - You can avoid using COUNTX because you're already working with distinct counts and conditions directly in CALCULATE.

Helper_Measure =
VAR _1 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), NOT(ISBLANK(HighlightGBS[HL - Business Cases])))
VAR _2 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), NOT(ISBLANK(HighlightGBS[HL - Storbageri])))
VAR _3 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), NOT(ISBLANK(HighlightGBS[HL - Bageri])))
VAR Samlet = _1 + _2 + _3
RETURN Samlet

Hopefully it works, If this still doesn't produce the expected results, you may need to check for how the data in HighlightGBS is structured