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.

 

ABCCount
25 302
   0
1030503
 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)

1 Reply

  • 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)