Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Help for counting measure values

Hi Experts, I need to count below measures A,B and C if the values are not blank using DAX. Please help.   A B C Count 25   30 2       0 10 30 50 3   100   1
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago
    # =
    VAR A = IF(ISBLANK([A]),BLANK(),1)
    VAR B = IF(ISBLANK([B]),BLANK(),1)
    VAR C = IF(ISBLANK([C]),BLANK(),1)
    RETURN
    IF(ISBLANK(A+B+C),BLANK(),A+B+C)
Anonymous's avatar
Anonymous
Not applicable
2 years ago
# =
VAR A = IF(ISBLANK([A]),BLANK(),1)
VAR B = IF(ISBLANK([B]),BLANK(),1)
VAR C = IF(ISBLANK([C]),BLANK(),1)
RETURN
IF(ISBLANK(A+B+C),BLANK(),A+B+C)