Forum Discussion

DK-C-87's avatar
DK-C-87
Helper I
1 year ago
Solved

Convert calculated column into a Measure

I've got this calculated column :  Helper = VAR _1 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant]), HighlightGBS[HL - Business Cases] <> BLANK()) VAR _2 = CALCULATE(DISTINCTCOUNT(HighlightGBS[Plant...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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

     

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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