DAX function to count all other DAX functions

Question

Hi Community&nbsp;&nbsp;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 other the other measures and provides a total count of how many produce a result.Below is an example of how I see this workingReference #Measure 1Measure 2Measure 3Measure 4Measure 5Measure 6How many of the other measures output a result12345&nbsp;&nbsp;1&nbsp;&nbsp;254322324516545656un checked&nbsp;3&nbsp;46787224&nbsp;&nbsp;&nbsp;3&nbsp;Thank youRichard

owenauger · Accepted Answer

Hi&nbsp;cottrera&nbsp;
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?
&nbsp;
Regards

Forum Discussion

DAX function to count all other DAX functions

2 Replies

Related content

Count function is doubling

DATESYTD function

DAX Studio space after function name

function enable staging

function behavior

Reference #	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5	Measure 6	How many of the other measures output a result
1234	5			1			2
5432	2	3	2	4	5	1	6
5456	5	6	un checked		3		4
6787	2	2	4				3