Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

DAX function to count all other DAX functions

Hi Community    I have a report that has a visual table containing a set amount of DAX functions. Some produce results , were as others do not. I would like a final DAX function that counts all ot...
"Need Help"
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi cottrera 

    I would suggest creating a measure that assembles the existing measures in a single-column table then counts the nonblank values.

    Here's how I would do it:

    Nonblank Measure Count =
VAR MeasureValues = {
    [Measure 1],
    [Measure 2],
    [Measure 3],
    [Measure 4],
    [Measure 5],
    [Measure 6]
}
RETURN
    COUNTROWS (
        FILTER (
            MeasureValues,
            NOT ISBLANK ( [Value] )
        )
    )

    Does this work for you?

     

    Regards

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
3 years ago

Hi cottrera 

I would suggest creating a measure that assembles the existing measures in a single-column table then counts the nonblank values.

Here's how I would do it:

Nonblank Measure Count =
VAR MeasureValues = {
    [Measure 1],
    [Measure 2],
    [Measure 3],
    [Measure 4],
    [Measure 5],
    [Measure 6]
}
RETURN
    COUNTROWS (
        FILTER (
            MeasureValues,
            NOT ISBLANK ( [Value] )
        )
    )

Does this work for you?

 

Regards